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:

MicroStrategy 101 on Facebook

MicroStrategy

MicroStrategy 101 has been a started by me for broadcasting the posts on the blog and actively providing small help on facebook itself. All the blogpost links are posted on facebook page too. Post freely. You don’t require a facebook account for this. Senthil is actively managing this facebook page.

 

Please share you wacky MicroStrategy idea here of on facebook. Keep coming for great MicroStrategy stuff.