COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: en1 on 28 Apr 2015 05:58:28 AM

Title: RoleValue for Root member
Post by: en1 on 28 Apr 2015 05:58:28 AM
Hi!
I need formula like this : roleValue('Day_last',currentmember([Data Item1]))
where [Data Item1] some hierarchy

'Day_last' - custom role value

in this case - error: The query contains a role value function with an invalid first argument

but if [Data Item1] is set members from this hierarchy except root member formula roleValue('Day_last',[Data Item1]) works.

It seems problem in use roleValue function for root member?