Saturday, August 25, 2012

Null values in metrics used in cube reports

Question:

A cube consists of 10 attributes and 10 metrics out of which few are simple metrics and few are compound metrics. When the compound metric is used in the intelligent cube report along with only 2 attributes from the cube it does not show up data but when all the 10 attributes from the cube are used they show up the right data. What needs to be done to fix this issue?


Solution:
In the metric definition edit->Subtotals/Dynamic Aggregation. Set dynamic aggregation to sum and then check

No comments:

Post a Comment