Nested List Report Containing a Data Item That is Grouped More Than Once Does Not Run After Upgrade

When you upgrade a nested list report that contains a data item that is grouped in both lists, the report does not run.

The following error occurs when the report is run against a dimensional data source and both lists are using the same query. This error does not occur if the report is run against a relational data source.

OP-ERR-0199: The query is not supported. The dimensions on the edge are inconsistent. The dataItems from dimension="[Product line]" must be adjacent.

For example, you have a list that contains the grouped items Product line and Product type and a nested list that contains the data items Year, Quarter, Product line, and Unit sale price. Year, Quarter, and Product line are grouped items in the nested list.

To resolve the issue, delete the data item that is grouped in both lists from the inner list.

Procedure

  1. Click anywhere in the report.
  2. Click the Show properties icon Show properties icon, and In the Properties pane, click the Select ancestor icon and click the List link that represents the inner list.
  3. Double-click the Grouping & sorting property.
  4. In the Groups pane, select the data item that you want and press the Delete key.