Relationships Not Maintained in a Report With Overlapping Set Levels

In a report, the relationship between nested or parallel member sets at overlapping levels in the same dimension may not always be maintained.

For example, a named set in the data source that contains members from both a Year and Month member is nested under Year, but is not properly grouped by year.

In another example, an error message such as this appears:

OP-ERR-0201 Values cannot be computed correctly in the presence of multiple hierarchies ([Product].[B1], [Product].[Product]) that each have a level based on the same attribute (Product).

This problem occurs in the following scenarios involving non-measure data items X and Y, which overlap in the same dimension:

  • X and Y together as ungrouped report details
  • Y nested under X
  • Y appended as an attribute of a group based on X

When using named sets, or sets that cover more than one level of a hierarchy, do not use sets from the same dimension in more than one place in the same report. They should appear on only one level of one edge.