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.
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