Hi,
I am working on a business rule to be executed from a data form in Hyperion Planning Version 11.1.2.1. Part of the functionality of the business rule is to get the parents parent of the shared member.
In entity dimension i have primary hierarchy and alternate hierarchies.
Entity
Legal Consol (Primary Hierarchy)
Management Reporting (Alternate Hierarchy)
UnConsolidated (Alternate Hierarchy)
I have defined a variable vEntity in calc manager and value to that variable will be populated from the data form once the user selects the entity value from the primary hierarchy. I need to come up with the functions combination to get the parents parent of vEntity value from alternate hierarchy Management Reporting.
I tried the following options @IDESCENDANTS(@PARENT("Entity",@SHARE({vEntity}))) and i am getting the following error
'Error:Invalid member name [@PARENT("Entity",@SHARE("10006_1168944"))] Rule
"10006_1168944" is the default value i defined for the variable.
I considered SPARENTVAL but i believe this function returns the value of that parent not the parent member name.
I appreciate your inputs on this.
Thank you
Ashok