Tuesday, December 4, 2012

How to apply thresholds to all levels on Outlined Reports?

When outlines are applied on grids in reports and a threshold is applied on it, only the lowest level have the threshold conditions applied. In order for all the levels to have thresholds applied, go to Data->Thresholds->Enable "Apply the threshold on metric and subtotal values".

Tuesday, November 20, 2012

What is quick switch and how to enable it in MicroStrategy Report Services Documents?

Quick switch is a feature in MicroStrategy Report Services Documents which is used to switch a dataset report between grid view and graph view in interactive mode or flash mode. A quick switch button will be displayed on left top corner of dataset report when hovering the mouse on top of the dataset report. The report switches to grid view (if it's in graph view currently) or graph view (if it's in grid view currently) when clicking on the the quick switch button, as shown below:

"Web change view mode" privilege under "Web Reporter" should be assigned for a user to be able to see quick switch button in Web.

In Desktop 

  • Right click on the dataset report in document editor
  • Navigate to "Properties"  and switch to the  "Grid" tab.
  • Check the "Quick switch" check box.
In Web
  • Right click on the dataset report in document design mode.
  • Click on "Properties and Formatting..." on the menu.
  • Click on "Layout" in the popped out dialog.
  • Check the "Quick switch" check box.    

Friday, November 16, 2012

How to show the grid on top of the graph in a Grid Graph View report through customization?

In MicroStrategy Web, when a Grid Graph View report is executed, the grid always appears below the graph.

In order to have the grid appear on top of the graph, follow the steps below:

  1. Make a backup of the ReportGridGraphLayout.xml file in the WEB-INF\xml\layouts folder.
  2. Open ReportGridGraphLayout.xml and interchange the following two lines, so that grid is on top of the graph:

      <mstrlayout:render name="graph" />
      <mstrlayout:render name="grid" />
  3. Restart the Web Server.

Thursday, November 1, 2012

Wednesday, October 10, 2012

What is Closed Loop BI?

Data input and write-back capabilities is Closed Loop BI. 

Executives can interact quickly with reports - by entering data, approving requests, adjusting forecasts, adding comments, uploading photos, scanning products, and more. In an instant, these actions are sent to transaction systems, triggering new business processes and accelerating business activity.
Transactional capabilities can be embeddde in Mobile devices on iOS and Android phones and tablets with MicroStrategy Mobile - and in Dashboards accessible through a Web browser with MicroStrategy Web.

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

Thursday, August 30, 2012

What is the command to start/stop IS and Listener?

Create a script file like below to stop and start the Intelligence Server and the Microstrategy Listener and save it as "services.scp".

/*For the Intelligence Server*/
STOP SERVER IN "<machine name>";
START SERVER IN "<machine name>";
/* For the Listener*/
STOP SERVICE "MAPING" IN "<machine name>";
START SERVICE "MAPING" IN "<machine name>"
Construct the following command with the above script file and save it as "services.bat"

cmdmgr -n "MicroStrategy Analytics Modules" -u "Administrator" -p "password" -f 

"C:\Documents and Settings\machine\Desktop\Services.scp" -o "C:\Documents and Settings\machine\Desktop\Services.log"And you can use this .bat file to start and stop the Intelligence Server and the Listener.

Wednesday, August 29, 2012

How to enable thresholds on data markers in line graphs?

Create a report say with Year attribute and Revenue metric.
Create a threshold say if Revenue between 3500000 and 400000 then select background color as red.
Then enable the button on top left Enable thresholds on graphs.
See screenshot below


How to enable/disable change journaling for a project?

The following procedure describes how administrators can enable or disable change 
journaling for all projects within a project source:

  1. In Desktop, log into a project source. The user logging in to Desktop must be granted the "Audit Change Journal" privilege.
  2. Expand Administration, and then expand System Monitors.
  3. Right-click Change Journal Transactions and select Manage Change Journal. 
  4. To enable or disable change journaling for this project source, select or clear the Enable change journaling check box.
  5. To enable or disable change journaling for all projects in the project source, select the Apply to all projects check box.
  1. If the desired action is to disable for all, but "Enable change journaling" is unchecked, 
  2. perform the following actions in this order:
    1. Check "Enable change journal" and "Apply to all projects".
    2. Click OK.
    3. Return to the Change Journal Manager.
    4. Uncheck "Enable change journal" and check "Apply to all projects"
    5. Click OK again. This will disable the change journaling for all projects if 
  3. "Enable change journaling" was not checked to begin with.
  4. Click OK. Change journaling should be enabled/disabled for each project,
depending on whether the option has been checked or unchecked.

How to create a button in a dashboard that opens another dashboard or page?

In dashboard go to Insert->HtmL Container. Inside the container paste the below code

<INPUT TYPE="button" value="Link" onClick="parent.location='http://www.microstrategy.com'">
<INPUT TYPE="button" value="Link" onClick="parent.location='http://www.microstrategy.com'">

Value - Give name of the Button here.

You can open another dashboard by placing it in the location properties.


where you need to replace the localhost by the server name and document id 

Tuesday, August 28, 2012

How to limit the number of records in a report?

1. Create a metric with definition Max(1) - Max
2. Create another metric on top of this metric Max- RunningSum(Max)
3.With the report open, add a report limit against the Running Sum metric so it only returns top five row's records.
To achieve this, go to Data > Report Data Options > Report Limit> Modify to specify the report limit definition -Rank(RunningSum) Top 5

Saturday, August 25, 2012

What is the life time of an element cache?

The Element cache is always saved in MicroStrategy Intelligence Server memory. When
 MicroStrategy Intelligence Server is restarted, this cache is purged. When the maximum memory for the element cache is full during run time, the least recently used cache is removed to make way for the newer elements added to the element cache generated cache. Also, it is possible to purge the element caches manually by using the option 'Purge Element Caches' available under the Administration -> Projects menu.

Also element caches are created per pass through login.

How to format a legends position in a flash widget?


Whenever I create a flash guage  widget, the legend is too far to the right.  Even when I horizontally expand my panel, the legend gets cut off.  Is it possible to format the position of the legend in the flash gauge widget?


Go to the actual grid report and change to graph mode->Advanced Options->Select gauge. Then go to graph options and do the settings as per the screesnshot then you will be manually able to move the legend around in the chart.

Then use it in the document and select flash type as gauge wid

Null values in metrics used in cube reports


A cube consists of 10 attributes and 10 metrics out of which few are simple metrics and few are compound metrics. When the compound metric is used in the intelligent cube report along with only 2 attributes from the cube it does not show up data but when all the 10 attributes from the cube are used they show up the right data. What needs to be done to fix this issue?

In the metric definition edit->Subtotals/Dynamic Aggregation. Set dynamic aggregation to sum and then check

Thursday, August 23, 2012

How to hide column headers for a grid report in a document?

Go to Grid->Options. In General Tab->Header->Uncheck show column headers

How to order an Attribute in a custom fashion


I have a Month attribute which has only a desc form having values Jan, Feb, mar...These months are not getting properly ordered in the report from Jan to Dec. How to achieve this?


Add the grid to the dashboard. Double click the grid and perform custom sorting by right clicking on the attribute->Sort option (based on MSTR version)

Create another form for the attribute with the following expression

ApplySimple("case when  #='Jan' then 1 when #2='Feb' then 2 when #3='Mar' then 4....
when #0='Dec' then 12 end",Month@ID)

Then in Data->advanced sorting->Sort by the form created.

Use of a report Limit


I have a report with several filters one of which is metric is not null. I am also applying a bottom 5 ranking metric on the report.Unfortunately one of the bottom 5 is one that is filtered out because of the first filter (it's null on a particular metric). This wouldn't be a problem but my bottom 5 filter only now shows 4 values. How do I make the report to filter out the null values and then apply the rank.


Move the Bottom 5 ranking filter from report filter to a report limit. A report Filter places a where clause in the query but a report limit places a having clause.

The report limit can be applied at Data->Report Data options->Report Limit.

Wednesday, August 22, 2012

Why does group by not work in some queries with attributes and metrics?


Requirement is that I need to create a report with two attributes and 1 metric from two different tables. I created a Logical table by unioning both the tables and took out the three columns from the UNION query. I then created 2 attrubutes and 1 fact (this was eventually converted into a Sum metric). Now when I create the report, the group by for the metric works when I add one attribute and 1 metric, but does not group by when I add the second attribute. Everything works, but the group by is removed and the sum part of the metric itself is removed from the sql (in the SQL View).


Check if in both the tables "The key specified is the true key for the warehouse table" option has been checked. IF checked then uncheck it and update the schema and then try.

This setting is applicable only when all the attributes listed as table keys in the 
logical view of the fact table.

Therefore, when checked, this setting forces to not aggregate the data and to pull only 
from the fact tables directly. 

How to find the day difference between two dates in MicroStrategy?

Create a metric and place the following definition there


where Date 1 and Date 2 are attributes

Tuesday, August 21, 2012

How do you find out the reason why a report is not being used for dynamic sourcing?

VLDB properties may be enabled in Intelligent Cube reports and user reports to include 

Dynamic Sourcing diagnostic messages in SQL View. Report designers can then view the 

messages immediately without accessing the Intelligence Server machine.

In an Intelligent Cube report, the following log is available for SQL View:
  • Cube Parse Log
In user reports, the following logs are available for SQL View:
  • Report Parse Log
  • Mismatch Log
  • Extended Mismatch Log
If the Cube Parse Log is enabled in SQL View and the Intelligent Cube is fully available for 

Dynamic Sourcing, the following will be seen at the bottom of the cube report's SQL View:

Dynamic Sourcing Logs:

Cube Parse Log:

Intelligent Cube is eligible for Dynamic Sourcing

The Cube Parse Log may identify reasons why the cube, or certain metrics within the cube, are 

not available for Dynamic Sourcing. Here, one of the required outer join properties was not 


Cube Parse Log:

Intelligent Cube is ineligible for Dynamic Sourcing


Error code legend:
CMI_VLDB_INCOMPLETE_LOOKUP_PROBLEM - The Intelligent Cube cannot be used for 

dynamic sourcing because of lookup table problems

To illustrate report parsing and mismatch messages, consider an Intelligent Cube containing 

the Month attribute and Revenue metric. If a user report includes Month, Revenue and Profit, 

the three logs together produce the following messages, explaining that Profit in the user 

report could not be found in any eligible cube.

Dynamic Sourcing Logs:

Report Parse Log:

Report is eligible for Dynamic Sourcing

Mismatch Log:
The report parsed OK, but no cubes were found to match
Could not use cube: Cube with transformation Error:
Report Metric vs Cube checks failed.
Extended Mismatch Log:
The report parsed OK, but no cubes were found to match

Monday, August 20, 2012

How does the different document sections work in MicroStrategy

I have created a sample document with year , month and the required metrics. 

In detail header I have created text boxes which is available in insert tab and typed the required column names.

In the detail section I just drag dropped the attributes and metrics from the dataset on the left and placed them correctly aligned below the static headers.
The detail section gives you one row for every attribute element 

next for the subtotals or grand totals , it needs to be placed in the detail footer. Drag drop the metrics alone in teh detail footer
and add a static text box to the left called Total.

Refer screenshots of the output.(first 3)

Next is an example where I placed year in the group and when you do that a header and footer gets created for year apart from detail footer.

So now when I place the metrics in the year footer it creates subtotal for every year and  the metrics placed in the document footer calculates the grand total.

See screenshot 4 and 5

Rule of Thumb

1. When a metric is placed in detail section then it displays values for every row.
2. When metric is palced in document header/footer or detail header/footer then it gives grandtotals.
3. When placed in page header or footer gives page totals.
4. When metrics are placed in group header or footer it gives group subtotals

How to Enable Advanced Qualification Filter in Desktop?

Advanced qualifications allow you to create the following:

  1. Custom expressions, which are customized filter expressions. You can use Apply functions and you can create relationship filters.
  2. Joint element lists, which join attribute elements and then filter the result sets.By default, the Advanced Qualifications option is not displayed in the Filter Editor.

It can be enabled at Tools->My Preferences->Editors->Filter->Show Advanced Qualification.

Friday, August 17, 2012

How do you handle report overflow in pdf?


I have 3 datasets in which 2 of them are small reports which I placed at top portion of the document where as the third dataset is a big one and I placed this at the bottom of first two reports. All the three datasets fetch data for last 7 days. When I run this documnet in desktop and view this in pdf view the third report is overflowing to the next page, is there a way we can limit this so that it would fit in one page per a day. Third report has 150- 200 rows per a given day. In web we can scroll down the report to see all the rows but looking for a way to restrict the overflow in pdf. This document has to be delivered through email as a pdf attachment to the users.


Following are the options

1.Make the fit to 1 page setting in Page Setup of the document but this will fit all the three grids in one page. 
(Screenshot 1)


2. Keep 2 grids in one section. Then insert section below and place the third grid in the second section. Then force new page after first section (Screenshot 2). That way the third grid will be in another page and also make the page 1 setting.


3. If you want the  third grid alone to dispkay per day in pdf. Place 2 grids in one layout then Create new layout. IN that place day in grouping section as I have placed year in the grouping section of the layout(3 screenshot). Right Click on group and set the properties to page break between groups

Is it possible to view the Metadata 's schema ?

You can export the schema of Enterprise Manager by going to Schema->Export Project Schema

Attached is the screenshot.

Also you can use the architect on the Enterprise Manager to view the metadata tables and relationships