How do i view the sql for a metric that is being used in a microstrategy dashboard?
I am trying to extract all the business logic that is stored in the microstrategy dashboard/cube
There two types of metrics- regular microstrategy metric- for which sql is generated; other derived metric calculated from other regular metrics
I am assuming you have a cube- and you have regular metric Create a grid report from the cube with just the metric and the attributes shown in the dashboard and view the sql.
If value shown in the grid report(non cube) does not match with one in dashboard.. issue is with dynamic aggregation