Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Smartlist in Calc Script with HSP_ID function in PBCS

GhaidaBKMay 31 2017 — edited Jul 25 2017

So i am trying to use this cool feature in smartlist that has been posted in this blog :Hierarchy-driven Smart Lists and using them in Calc scripts ~ Oracle - Hyperion Labs

but for some reason , it's not working , so i did the below scenario :

in the smart list , there is a member associated with ID :58579 so for example I executed this formula and it worked :--> @member(HSP_ID_58579) = Paymentvalue ;
but when i tried to make it dynamic it does't work --> @member(@CONCATENATE(“HSP_ID_”, @hspnumtostring(58579))) = Paymentvalue ;

Is there a logic reason why the second formula is not working ?

Thank you,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2017

Added on May 31 2017

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

17 comments

9,786 views