Relationships Not Maintained in a Report With Overlapping Set Levels
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.