COGNOiSe.com - The IBM Cognos Community

Hi,

I have a dimensional report  and I have a level sub regions,

I wanted to replace all the members in the subregion that starts with UnAssigned to ALL.

I may get example values like  UnAssigned - Prime -002,  UnAssigned - Habel -005 etc..


All these word UnAssigned must be replaced with ALL - Prime - 002 and All - Habel - 005 in run time.


My current data item just has the subregion level in it.

Can anyone help me with the code to make this replacement at report level.

Thanks,
Nithya

Quote from: nithya1224 on 25 Apr 2016 10:58:31 AM
Hi,

I have a dimensional report  and I have a level sub regions,

I wanted to replace all the members in the subregion that starts with UnAssigned to ALL.

I may get example values like  UnAssigned - Prime -002,  UnAssigned - Habel -005 etc..


All these word UnAssigned must be replaced with ALL - Prime - 002 and All - Habel - 005 in run time.


My current data item just has the subregion level in it.

Can anyone help me with the code to make this replacement at report level.

Thanks,
Nithya

Hi,

You'd probably need a filter() function to isolate these members:

filter([your SubRegion level], caption([your SubRegion level]) contains 'UnAssigned')

You could then summarise the measure values for this set

aggregate(currentMeasure within set [your expression above])

If you named this final calculation as ALL, that's the row heading you would see displayed.

MF.

No this is different ,

I have to show all the members of subregion , if there are few members having value with UNASSIGNED then replace the members name who have unAssigned with ALL test.
           UnAssigned - 000 -    Should be shown as All -006
           UnAssigned - 012 -    Should be shown as All -012
           
Thanks,
Nithya