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!
Is there any way to compare the value in a text account with a member's name? I'm asking this question because our client want to manually upload the Brand (which is a dimension) information of the related data through a form onto "No Brand"(the default member of Brand dimension), and we need to use CalcMgr Rules to copy the data from "No Brand" to the required Brand Dimension member with other dimension unchanged. I've find that if using the function [[PlanningFunctions.getIdForString("text")]], then I can compare the value in a text account with a string. However, when I try to insert a function @Name(@currmbr("Brand") instead of using the specific member name "BR_0000050L" , the rule validation could not get passed. Could someone help me with this problem? Or is there any way of using smart list to solve this problem?