Many-to-many dimension showing wrong numbers
We have a many to many dimension that is producing incrorrect numbers. It had gone unnoticed for a long time, till we created an equivalent relational report and it has now been highlighted. For a relatively small proportion of leaf level items, NULL is returned from MDX. At the higher aggregated level, the numbers are smaller in the cube than they should be (about 5 or 10%).
Upvotes: 5<=-=Aug 18 2006 2:48PM=-=>
We are investigating this issue and will get back to you. There are several common dimensions between the two measure groups, however all but one are reference dimensions. There is most likely some data discrepancy between the two measure groups w.r.t. the reference dimensions.