Forum Discussion

rleve2's avatar
rleve2
New Contributor
10 months ago

Exporting List of Entity Orphans

Is there any way to export a list of orphaned entity members?  We pull in hierarchy information from SAP and recently over 1000 entity members were blocked in SAP.  This resulted in them going into o...
Metadata
  • Henning's avatar
    Henning
    10 months ago

    I was referring to the Grid View in a dashboard. Adding to that a data adapter using SQL. After Chris' post, I realized the confusion.

    What you found is obviously better, basically a pre-packaged solution for what I suggested. Good to know Application Reports has a report that includes orphans!

Henning's avatar
Henning
Valued Contributor II
10 months ago

Hi, one should be able to create a grid view or another preferred format to display orphaned members. I am not aware of a native api function to do that at the moment (though I have never looked into it), but at least a SQL query should do.

On another (in my view more important) note, this sounds like there is a rule set up to just push entity members from SAP into OneStream without proper process. I would recommend to discuss with with the system architect to add a process around that, possibly utilizing the Marketplace solution ACM / Application Control Manager. To me, a process where entities are just imported and may end up being orphans without any list of failures or safeguards preventing this would be hard to accept. Especially when the number of entities is not just a handful which may be managed manually, but in the thousands.

You can also think about opening a case (ticket) and get in touch with the OneStream Remote Consulting team to discuss whether they can help you set up a possibly safer option.

  • rleve2's avatar
    rleve2
    New Contributor
    10 months ago

    Unless I am doing something wrong, orphans don't show up in the Grid view.  We did find that we can export them using the Application Reports dashboard under Metadata Analysis.  There is an option to create a report of all Orphaned Members.  From there you can export the list into a variety of file formats.

    We are using ACM and generally have checks in place to catch these.  The issue was with the number of blocked entities coming in this month.  This is not something that is normal for us.  Thanks for the input, really appreciate it.

    • Henning's avatar
      Henning
      Valued Contributor II
      10 months ago

      I was referring to the Grid View in a dashboard. Adding to that a data adapter using SQL. After Chris' post, I realized the confusion.

      What you found is obviously better, basically a pre-packaged solution for what I suggested. Good to know Application Reports has a report that includes orphans!

    • cbriscoe's avatar
      cbriscoe
      Contributor
      10 months ago

      The orphan parent will not show up on the Grid view but on the Members list which will show up in the Grid view, allowing you to view and export them if necessary. see below.

      This screen below is showing Grid view - now you can use the packaged report or write a report to just show them.

      Nice - enjoy OneStream ğŸ˜Š

  • cbriscoe's avatar
    cbriscoe
    Contributor
    10 months ago

    I agree with Henning. Please make use of the Grid view functionality to filter orphaned entity members. We recommend adding some type of validation to the Integration process to identify orphaned entities. 

    Enjoy OneStream.