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
Tagged on:                 

2 thoughts on “Microstrategy metrics relationship

Leave a Reply

Your email address will not be published. Required fields are marked *

38 + = 43

This site uses Akismet to reduce spam. Learn how your comment data is processed.