Forum Discussion

pling's avatar
pling
New Contributor II
3 years ago

Retrieve Parent property

Hi All, I am trying to find a way to create a report that shows the Entity and the Parent in a column next to it. I tried to do this by using the functions =XFGetMemberProperty() and =XFGetRelation...
Reports
db_pdx's avatar
db_pdx
Valued Contributor
3 years ago

Hi pling: you can get the parent-child in an export directly from the Application -> Dimensions tab in OneStream.

Steps:

  • Open OpenStream
  • Navigate to Application > Dimensions
  • Select your entity hierarchy
  • Go to the Grid View tab
  • Set the Grid Settings
  • Check Display Parent-Child at the top
  • Set your Member Filter query to E#Root.DescendantsInclusive (or whatever portion of the hierarchy you want)
  • Refresh
  • Right-Click > Export to CSV/Excel

Cheers    -DB