Today I had a Microstrategy reporting problem: on my report there are two metrics, one is total number of incidents and attribute month; the other is total amount of payments received.They come from two different tables and have no relationship at all, my report just needs to put them together for ease of use.
When putting them together,Microstrategy for some reason thinks they are related therefore a join was established which is of course a Cartesian join. The solution is on the second metric(amount of payments), on level(dimensionality) specify the attribute month but filter set to “ignore” and group set to “none”, problem sovled!
The actions is like include an attribute in order to exclude it, it’s odd isn’t it?
Microstrategy metrics relationship
Fantastic post,very helpful, thanks!
Pingback:Frederick