Collecting the value of a parent list in calculations

Highlighted
Previous Contributor

Collecting the value of a parent list in calculations

Hi, I want to collect the value on the parent membrer for the employees list of my source line item to calculate my target one I did an example like this one target_lineitem=source_lineitem[SELECT: Employees.PARENT(ITEM(Employees))] but it doesn't work can someone help me.

1 REPLY 1
Highlighted
Previous Contributor

RE: Collecting the value of a prent list in calculations

I think it  may  be the syntax Employees.PARENT(ITEM(Employees))], is it  looking for a list item named PARENT(ITEM(Employees)), not the actual parent? I believe you have to  take a two stage approach [list=1]
  • Create a new line item in target cube called 'Parent Employees'' formula PARENT(ITEM(Employees)) (format  is the list Employees)
  • Use the formula target_lineitem=source_lineitem[LOOKUP: Parent Employees]