Retrieve Parent of member in SmartView / HSGet
Hello Experts,
Is there any way to retrieve the parent of a member in Excel?
I have a file that uses HSGet (it was a necessary evil to achieve the layout i needed), and one of the requirements is to show the Parent of a Member in the rows.
so it would look SOMETHING like this:
Dept_123 EN_123 Prj_123 ParentofPrj_123
From my research I wasn't able to turn anything up (except a super old Hyperion command that is long since defunct)
Anyone have any idaes?
Tagged:
0