Skip to Content
author's profile photo Former Member
Former Member

How to maintain Hierarchy for non logical number ids in BPC

Hello, i have a dimension named 0ORGUNIT. The master data for that orgunit has been maintained in sequential order with many parent nodes in between. The list is big, and any time new number/ID can be added to any parent. The other part of this dimension is every parent has got data to be stored. As BPC cannot store parent data, all the members are taken as base level members

For Reporting purpose i need to show the same with parent and child relationships. How to handle this scenario?

Please find the sample hierarchy structure below.

ID Description PARENT 5000000 MD's office 5000001 CEO's office 5000000 5000221 Internal Audit 5000001 5000002 COO 5000000 5000222 Operations 5000002 5000223 Contact Center 5000222 5000224 Customer Service 5000222 5000225 Branch Operations 5000222



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 16, 2016 at 10:54 AM


    For the parent members on which you have to save the data concatenate them with _I or _D and make these base members whereas the ID with nos as parents. So in report you can show it with parent and child relation as well...

    As in your case 500000_I - MD office inputable etc.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Praveen,

      Probably the easiest way to implement this is END ROUTINE BADI. In that BADI you can read data from 0ORGUNIT and find out if a member is a node. Then add an _I member underneath.

      The only concern I can see with your approach is that if you want to make a base member a node in the next load. You won't be able to do this if that base member has some transaction data.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.