OP-ERR-0144 Grouping on a property or property expression

[srinidhi]

Hi all,

I am getting this error in 2 reports. could you please help me in solving this. I need it urgently. It is as follows:

OP-ERR-0144 Grouping on a property or property expression: dataItem="Month",expression="[__ns_0].[Time Hierarchy].[All Time Period].[Month].[Month0]" in valueSet="1" is not supported

OP-ERR-0144 Grouping on a property or property expression: dataItem="STRATEGIC_ACT_YEAR",expression="[__ns_3].[Strategic Active Year].[Strategic Active].[Strategic Active Year0].[Strategic Active Year0key]" in valueSet="0" is not supported

Thanks in advance

Waiting for your reply at the earliest.

Srinidhi.

[Arsenal]

I'm assuming you're not trying to group data items in a crosstab, because crosstabs are grouped by default

if not, then is this error on a report that's just been upgraded from lower versions to 8.4? If so, the following APAR recommends upgrading to 8.4 FP1:

https://www-304.ibm.com/support/docview.wss?uid=swg1PM13455

If that's not an option then try recreating parts of the report (drop the prompts etc.) and see if that works and if it does, you'll just have to recerate the entire thing

If this is not upgrade related, you'll have to manually validate the data items and find out which one is causing the error.

suggestion from elsewhere:

on the query explorer page on each and every query that is used on crosstab the following should be checked:
Auto Group & Summarize - NO
Override dimension info - NO
Define member sets - YES