Using Smart Lists of Type Members in Custom Calculations

Use these tips and the formula examples that follow to help you create custom formulas that refer to a value stored against a Smart List entry member.

For example, there is a Smart List containing Salary Grades, created based on the Salary Grades members in the Component dimension. To refer to the Smart List entry, you can use @CONCATENATE("HSP_ID_",@Name(@hspnumtostring(SLVal))), where SLVal is the member that the Smart List is associated with and Smart List values are input to.

For example, if custom script is in the OEP_WFP cube and you want to refer to a value stored against the Smart List entry member in the OEP_WFSC cube, write the code as follows:

"OWP_Salary Basis"= @XREF(_WFSCube_,"No Year","No Account", "No Job", @CONCATENATE("HSP_ID_",@Name(@hspnumtostring(SLVal))));

Refer to the out of box Calculation Manager rules (such as OWP_Synchronize Defaults) for more usage examples.