COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: AJAYC on 08 Aug 2017 06:44:24 am

Title: roleValue woes !!!!!
Post by: AJAYC on 08 Aug 2017 06:44:24 am
Hi All

I'm struggling with the roleValue function in RS with TM1 attributes.

I have a "YearMonth" TM1 dimension, and have prompted for an element "201706" from within it. The dimension contains an attribute called "YearMonthYTD", so for this element selected it has a unique value of "201706YTD".

The attribute value nicely corresponds to a hierarchy within the dimension called "201706YTD" which contains members which should provide the appropriate value.

In my testing I am trying to retrieve the attribute using a data item, but I just can't seem to pickup the attribute let alone convert it to a the member I need.

I'm trying the following:

roleValue ('YearMonthYTD',[blah].[blah].[blah]->?promptedYearMonth? )

In a crosstab, I have two columns, one of which is the prompted "201706" and the other which is the data item for the YTD equivalent but both return the same numbers - that for "201706".

Has anyone successfully utilised this functionality in RS ?

Thanks
Ajay
Title: Re: roleValue woes !!!!!
Post by: New_Guy on 08 Aug 2017 09:47:57 am
Hi,
The function roleValue is used in to get business key, memberCaption, MUN.
item(filter([blah].[blah].[blah],roleValue('_memberCaption',[blah].[blah].[blah]->?promptedYearMonth?) ,0)). Check the dimensional functions in the expression window for the right syntax.
You can try using the YTD members in the prompt and use
[blah].[blah].[blah] ->  ?promptedYearMonth?

Good luck
New guy