Limitations When Summarizing Measures in DMR Data Sources
There are limitations when summarizing dimensionally-modeled
relational (DMR) measures and semi-additive measures in crosstabs
using the aggregation function count distinct, median, standard-deviation,
or variance. The following limitations can produce
empty or error cells when the report is run:
- The aggregation function must apply to all members of a level or all children of a member.
- To use OLAP functions in detail filters that are applied to a dimension that is not in the report, or is at a level below what is being reported, only the functions children, level, members, roleValue, and rootMembers will work.
- You cannot define detail filters that reference one or more measures and are set to After auto aggregation.
- You cannot define context filters that have more than one member from a dimension that does not appear in the report.
- Context filters that have more than one member from a dimension that appears in the report produce errors in all cells that are ancestors of the slicer members.
- If a crosstab has a row that is a set of members from one dimension (dimension A) and another row that is a set of members from another dimension (dimension B), and a context filter containing members from dimension A is defined, error cells are produced in the row that contains members from dimension B.
- If a context filter contains members from a dimension, and a crosstab has a row that is a set of members from a higher level than the slicer members, error cells are produced for that row.
- Error cells are produced when drilling down on a crosstab that has two nested levels.
If you do not consider these limitations in a calculation, the report may return inaccurate results.
If there is a non-measure calculation that returns a constant or contains a summary function, and the calculation has a lower solve order than the measure being aggregated, error cells are returned for the aggregated measure.
In list reports, error cells are produced as a result of these limitations if the list uses an OLAP function other than children, filter, level, members, roleValue, and rootMembers.