The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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