Skip to Main Content

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!

Referencing Smart List Member in Calculation Manager Rule

Daniel VillaniJul 24 2024

Hi, I have a Smart List defined to be a member list in a dimension called resource. I am trying to build a dynamic overhead allocation (similar to what's in the Projects Module).

In the example I have below, I want my Manufacturing Overhead→No Resource to be equal to 100% of my Total Labor Expense for Jan (P1). When I run the rule, I get 0 as my answer. I added some @return statements to check to make sure my SL function was returning the Total Labor Expense Member, so I know that piece is working. It just doesn't seem to be pulling a value for that cross dimensional member. I tried simplifying my formula as well to remove the multiplication and addition to just test the data pull but it looks like it is pulling 0 for the value. Is there something I need to change in my logic to get this to work dynamically?

This post has been answered by Eggy on Aug 9 2024
Jump to Answer
Comments
Post Details
Added on Jul 24 2024
4 comments
617 views