Advanced Metric Creation Tool

MicroStrategy provided a simple little tool in 9.0.1 to generate these metrics at a time.

Eg : suppose you have a metric "Revenue", obviously we need some more metrics in our real time like last years revenue, last quarters revenue...so to creating all these metrics manually it is tedious process, Advanced metric tool will help us here. 

Steps :

1. Right click on a particular metric (Revenue) & select advanced metric. 
2. select which filters do you want
3. select which transformations do you want
4. Run it.

you will get bulk of metrics with the combinations for the metric "Revenue".  This is some what better rather than creating all these metrics manually. 

Refreshing I-Cubes & Dynamic Sourcing

Refreshing I-Cubes :  

we can refresh the I-cubes in 2 ways.

1.     scheduling I-cube 
2.     Creating incremental refresh report for the particular I-Cube

Scheduling I-Cube :  we can specify when I-cube should refresh based on time based trigger / event based trigger.
Incremental refresh I-cube :  It is available from Mstr version 9.2.x, using this we can specify the when I-cube should be refresh based on the things..

Insert
Delete
Update
Update Only.

we can update it manually also , right click on the I-cube and select run (updating).

Dynamic Sourcing :

Dynamic sourcing is available from 9.2.x, we can enable / disable this feature in project configuration wizard. once we enable the dynamic sourcing the reports might be get the data from I-cubes without we link the report to particular I-Cube.

No need to link the reports, Small example :

I-Cube1 Objects are :  Attributes : A,B,C,J & Metrics : E,F,K
I-Cube2 Objects are :  Attributes : A,B,C,D,Y,Z & Metrics : E,F,G,H,I

suppose we run the report1 having the  attributes  A,B,C,J & Metrics : E,F,K obviously it gets the data from I-Cube1.  (Note : we didn't link this report to I-cube, due to dynamic sourcing feature it is getting the data from I-cube rather than database)

suppose we run the report2 having the attributes A,Y,Z & Metrics : E,G,H obviously it gets the data from I-Cube2.

suppose we run the report3 having the attributes A,Y,Z,L & Metrics : E,G,H,O obviously it gets the data from Database because same attributes / metrics are not published yet in I-Cube.