COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 05 Feb 2015 04:19:48 PM

Title: Bursting Report Warning
Post by: cognos05 on 05 Feb 2015 04:19:48 PM
Getting the below warning

OP-ERR-0144 Grouping on a property or property expression: dataItem="ShipToRegion",expression="rolevalue('_memberCaption',[Sales].[Customer].[Customer].[Regions])" in valueSet="40" is not supported.

Using a dimensional Cube.

Cross tab with a Region and Qty .

These region dataitem values and email id are seperately loaded in a relational table. Master detail re;ationship between region data item.

Used caption([Region]) to link.

Thanks,
Nithya
Title: Re: Bursting Report Warning
Post by: Raghuvir on 06 Feb 2015 01:23:34 AM
Quote from: nithya1224 on 05 Feb 2015 04:19:48 PM
Getting the below warning

OP-ERR-0144 Grouping on a property or property expression: dataItem="ShipToRegion",expression="rolevalue('_memberCaption',[Sales].[Customer].[Customer].[Regions])" in valueSet="40" is not supported.

Using a dimensional Cube.

Cross tab with a Region and Qty .

These region dataitem values and email id are seperately loaded in a relational table. Master detail re;ationship between region data item.

Used caption([Region]) to link.

Thanks,
Nithya

Hi ,

Please refer the below link.

http://www-01.ibm.com/support/docview.wss?uid=swg21635473

Hope it helps.

Regards
Title: Re: Bursting Report Warning
Post by: cognos05 on 06 Feb 2015 07:43:51 AM
I am using a Level from a dimension. How would I replace that with a top level item. I dint understand that. Can you explain me .

Thanks,
Nithya