Monday, November 4, 2013

Formatting a metric to Thousands

Eg of the Metric value:123412
Desired value (in '000) :1234
Eg of the metric value:-123412
Desired value (in '000):(1234)

In the metric formatting select Custom formatting and enter : #,##0,;(#,##0,);0

Thursday, August 1, 2013

General Design Recommendations for Dashboard

  1. Focus on Data first
  2. Design the dashboard with your target audience in mind
  3. Keep related data on a single screen
  4. Pay Attention to object placement
  5. When possible limit number of metrics
  6. Focus on Important Indicators like Trends, Variances and Performance States
  7. Group Like Items or Comparison Items Together
  8. Use white space or thin grey lines to separate groups of data
  9. Keep simple navigation in mind
  10. Limit the number of fonts in a dashboard

Wednesday, July 31, 2013

What are the considerations when exporting to excel?

  • Does not support overlapped objects
  • Lines and Rectangles do not display - Use text box border
  • Word wrappping does not work
  • Images with relative paths do not function well. Change to absolute paths or embed images
  • Choose excel compatible colors
  • Use ms excel supported graphs. Graphs not supported- gauge and combination graphs are not supported

Monday, July 29, 2013

What are the different types of layouts in documents?

Zone based Layouts
--Scorecards and dashboards
--Graphical Content
--Multiple tables and graphs
--On Screen Display
Banded Layouts
--Operational Reports
--Densely populated data
--Mutil-page repeating reports
Combined Layouts
--Classic Business Report is an example

What are the different types of documents?

Operational Reports

Orgainizes data into densely populated reports
Rows of details grouped in easy to read fashion

Classic Business Reports

Create business reports using charts and grids

Invoices and statements

Personalized for billing or communicating with recipients.
Predefined structure with dynamically populated fields.

Scorecards and Dashboards

Uses KPI's - measures that business used to determine its success.
Combines tables, graphs, labels, gauges, thresholds

Managed Metric Reports

Highlight measurements using conditional formatting

Sunday, April 28, 2013

Best practices on how to reference image using relative path

To reference an image using relative path, the following locations are required to store the image in order to display in multiple MicroStrategy products.
Relative path sample:

To display images on: MicroStrategy Desktop, Web, Mobile, Distribution Services:

For image to display on MicroStrategy Web Services:

Tuesday, March 26, 2013

What are the different ways by which a fact can be directed to a particular fact table?


There are three fact tables
Country_ID Revenue

Logical Size:100

Country_ID Year ID Revenue

Logical Size:200

Fact 3
Product_ID Revenue

Logical Size:300

I create a fact Revenue and check all the three tables.

In the report when I use Country Attribute and Revenue MSTR will hit fact table 1 as Fact 1 has the lowest logical size but if I want it to hit Fact 2 then four methods are available.

Method 1
I need to create a separate fact say Country_ID and check Fact2 table alone as source.
In the metric revenue right click the aggregation properties say Sum and you would get parameters in it. Select the Fact ID there as the newly created fact Country_ID

Method 2
Decrease the logical size of Fact 2 to 50 so that MSTR hits fact table 2. 

Method 3

Since Year Attribute is unique to Fact2 in the report add Year attribute to the report objects

Method 4

Create 3 separate facts for each fact table and three separate metrics and use them as required