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 orphan status in our OneStream instance when we updated our metadata.  The issue is that some of these orphans had data and that is causing reconciliation issues.  If I could export a list of the orphans, I could match them against all of the SAP entities that have data to determine which orphans needed to be restored.  Thanks!

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

      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.