Tuesday, September 18, 2012

Fix horizontal bar size in graph

When a bar graph is created in MicroStrategy, based on the categories the width of the bar keeps varying. In order to get a fixed size for it in Graph Options->Options->General->Check use minimum number of categories

Thursday, September 13, 2012

How do you get the New Grid Dialog box back once you have checked Dont Show this dialog in future?

Sometimes when creating a new report , we get the New Grid dialog box where we can select among Blank Report, Report Wizard, Report Builder and there by mistake we would have given Dont's Show this dialog in Future. Going forward a new report will directly open a blank report. In order to get back the New Grid dialog box we need to navigate to Tools->Desktop Preferences->Object Template and check the report option

Wednesday, September 5, 2012

How to create a left join between 2 dimension or lookup tables?

There are two tables Product Group and Product. If we add attributes Product Group and Product derived from the respective above 2 tables and set the join type of attributes to outer using Data->Report Data Options->Attribute Join type the left join will not happen. The solution is to create a metric out of the attribute say count(Product), add it to report objects of the report and  in Data->Report Data Options->Metric Join Type set it to outer.

How to fix column headers misalignment in Internet Explorer?

In report grid options unlock the column headers