Category Archives: Metrics

Object Prompt in Cube and RS Document (RS already discussed earlier)

Development, Metrics, MicroStrategy, MicroStrategy 9, Prompt

Earlier (actually long back), posted a topic about placing Object prompt in the RS document/ RS Grouping;

Source: http://www.microstrategy101.com/?p=130

Here is the similar trick to use object prompt in the dataset created from Cube;

  1. Create an object prompt with metrics (A, B, C, D)
  2. Create a cube with attributes and with above A, B, C, D metrics and create a data set using this cube
  3. Drag and drop object prompt from MicroStrategy Desktop window to the cube
  4. And it works…..I tested this in 9.3 and 9.2.1 version.

Starting from 9.3.0 String Function can be used in Derived Metrics

Development, Metrics, MicroStrategy, MicroStrategy 9

Starting from 9.3.0 String Function can be used in Metrics;

1. Create a Max (Attribute-1) as ‘Derived_metric-1’

2. Create a Max (Attribute-2) as ‘Derived_metric-2’

3. Create a third metric as ‘Concat(Derived_metric-1, Derived_metric-2)

4. Place it in the report……it works (verified in desktop)

 

Additional Tip: similarly, you can create count (attribute) on the fly (as derived metric) – Cool…..

Unused objects in MicroStrategy project

Metadata, Metrics

Open Object Manager
Connect to a project source and open a project, as shown below:

From the Tools menu, click on ‘Find Unused Objects’, as shown below:

A ‘Search for Objects’ dialog box opens up. Different options such as name and location, type, date etc. can be specified to narrow down the search, as shown below:

For example, to find all the metrics that are not used in the project select Metric in the Object Types tab and click ‘Find Now,’ as shown below:

All the unused metric objects in the project are displayed in the search results window as soon the search is completed, as shown below:

How to hide Metric column in MicroStrategy

Metrics, MicroStrategy

For hiding Metric column only in Web: (assuming that English language was the Locale.)

  1. On the Web Server machine, go to the default location of Web ASPxWEB-INFclassesresources and open up the file called MessagesBundle_en_US.properties.
  2. Go to the line ‘mstrWeb.1158’. For English language, ‘Metrics’ is the value.
  3. Delete the word ‘Metrics’ and leave one single space.
  4. Save the close the file.
  5. Restart Web server.

Note: If an environment is being accessed by users that may not be using the project default language, the administrator will need to go in and modify each MessageBundle properties file for that respective language and clear the mstrWeb.1158 Metrics reference.

————————————————————————————————-

For hiding Metric column in Desktop for Reports and RS documents.

1st method

  1. Goto Grid menu and check that Automatic Column width is disabled.
  2. Place the mouse between the Metrics column and the first metric on the report. Then, drag the column to the left until it is no longer present on the report:.

2nd method

  1. Open Options under Grid menu.
  2. Open tab Columns and Rows.
  3. Select radio button Fixed.
  4. Select Metric from dropdown menu and set 0 as pixen as width.

Metric Aliases

Metrics, MicroStrategy,

This is a little “don’t” that I stumbled upon recently.

Don’t create metric aliases that contain operators such as “-“, “+”, and so long. Although MicroStrategy allows you to do so, the database application (Oracle, Teradata,…) will nag you about expecting “something between – and ,” and of course, the report will stop executing.