OP-ERR-0144 Grouping on a property or property expression is not supported
Encounter a validation error creating a chart report against a Dimensional modeled Package.
Unable to Group a Member Property Data item in a Chart Report.
Validation error occurs:
OP-ERR-0144 Grouping on a property or property expression:
dataItem="Product name",expression="[__ns_0].[Product].[Product].[Product0].[Product name]" in valueSet="1" is not supported.
Resolving the problem
There is a restriction on Grouping a member property. when a member Property is used in a Chart it is automatically grouped, resulting in the validation error when validating to running the report.
The solution is to replace the Member Property Data item with a Member in the Chart.
This avoids the validation error and returns the required results in the chart.
Example: Go Sales (Analysis Package)
Member: found in the Members Folder of the Hierarchy
1. In the Chart, remove the Member Property Data item
2. Expand the Hierarchy and select the Member from the members Folder.
Report will validate and run successfully.
More support for:
Cognos Business Intelligence
Software version: 8.4.1, 10.1, 10.1.1, 10.2
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Software edition: All Editions
Reference #: 1635473
Modified date: 12 September 2014