Skip to Content
avatar image
Former Member

Produc 4 levels Hirearchy input

Hi Please any one help me in this requirement, searched lot in Forums but couldn't find this scenario to enter input data at all level combination and save data.

Requirement is attached in screen shot    in Document

1  Product Hirearcy

2. Input template which require all levels need to appear in template

3. Master data of PRODH4, PRODH3, similarly other two levels of PRODH1, and PRODH2

4.Transformation file

scenario is as mentioned below:

For this sales model created 16 dimensions , users want all levels need to appear in the input, if created at parent level then data not able to save because  1st,2nd and 3rd levels are Parents. So for this created 4 product dimensions like prodh1, prodh2, prodh3, prodh4, and all levels data maintain in 4 dimensions.

But since all combination became mess up, so created one more new dimension which will be all combination of all dimensions which exist in model as properties. Now I need to map in transformation file the data for this id.

Currently I'm getting actual values from cube from BI to BPC

Now my questions are two

1. whether I build new dimension which has all levels  and can input at all levels

2. or else should I need to create one more dimension which have all combination of dimension members in one dimension (which will be id's as some sequence numbers) and pull data from BI, but to pull data for this id, there is no object in BI.

screen shots in document

Transformation file



inputtemplate.jpg (107.9 kB)
prodh.jpg (9.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 26, 2014 at 07:34 AM

    Hi Silu,

    What was the reason to create so many dimensions instead of multiple hierarchies in a single product dimension?

    If you want to manually enter data on the "parent" level - then use write back badi with disaggregation. If you want just to load data from BW - then you can use dummy members and post processing...


    P.S. A lot of dimensions affects performance and report complexity...

    Add comment
    10|10000 characters needed characters exceeded

    • "As you said write back badi with disaggregation, i will try for this, but again users want to roll all data at top level."

      The idea of disaggregation write back badi is simple:

      1. User enter data on PARENT level (can't be saved) and press Save.

      2. Badi will check that data is coming to parent level and instead of generating error the data will be distributed to base members using some logic (have to be defined). The original value for parent will be deleted - no errors.


  • avatar image
    Former Member
    Dec 26, 2014 at 07:59 AM


    my new dimension is created like this, which had properties or again another dimensions

    Id     country   salesrep    prodh1   prodh2   prodh3   prodh4    region    subarea  mattype   profitcent

    1      AE         88               10101  1010101   10110111 1011011110  APAC         FERT      IVP

    10   AU          36             10101   1010101   10110112   1011011012  EMEA       HAWA    DES

    Here in this dimension ID is just normal number which not exist in BI, all other properties exist in BI and, i need to check the above  combination with cube in BI and get ID into Transformation file, and

    for signdata the direct infoobject value which exists in keyfigure in BI



    PRODH1 = 0PRODH1


    ID=  all combination of sales cube data in BI check with master data, if exists then take ID from dimension and pass here.




    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Shrikant Jadhav

      Hi Vadim/Shrikant Thank you to both of you for providing me solution, issue resolved now, user's are ok even though  data appears at child level. so currently in my scenario I didn't added INPUT_NODE. once again Thanks for help. Regards Silu