Two hierarchies in dimension

[Former Member]

Dear Experts,

I have a dimension that required to have 2 hierarchies because i want to summarize the value in two point of view.

In "A" section, there a dimension member with Parenth1 is correct.

But i want to have report like in "B" section, if i just group with certain properties, then the report i would get is like in section "C".

Can you tell me how suppose i setting the second hierarchy ?

Thanks,

Suprapto

[former_member210696 · Accepted solution]

Hi Suprapto,

Maintain two hierarchies as below -

ELG

     ELG-CD

     ELG-FN

     ELG-CF

          ELG-CF-CB

          ELG-CF-CF

Second as -

CD

     ELG-CD
     ABC-CD

and likewise..

While maintaining multiple hierarchies, you need to ensure that no father has two different sets of children under two different hierarchies which in your case is not there. So, you can easily maintain the structure as above.

Use property HLEVEL (system defined) under memberset to get the desired set of members in the report.

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/13/a6464673df4c97b49a9cb5f62c82ce/content.htm

Hope it helps!!

[venkatasreekar_krothapall · Accepted solution]

You said "No Parent should have two different sets of Children"

Why is that ??

If we have two different hierarchies (PARENTH1, PARENTH2) for the same set of IDs in a dimension.

ABC (parenth1)

   A1

   A2

XYZ (parenth2)

   A1

   A2

Can't we have below node (ABC) as part of PARENTH2 which is also present in PARENTH1 ??

ABC

   A1

   A2

[former_member210696 · Accepted solution]

Hi Venky

Consider this -

ID          PARENTH1          PARENTH2

A

A1          A

A2          A

B1                                        A

B2                                        A

In the above example, A is a parent level member that consists of A1 and A2 in hierarchy H1 and B1 and B2 in hierarchy H2. In this case, system can't decide that for A, what data it needs to aggregate, should it be A1 and A2 or B1 and B2 (As you know that in BPC, for any parent, data automatically gets rolled up).

Refer to this thread for more details -

http://scn.sap.com/thread/3189203

Hope it helps!!

[Former Member]

Hi,

http://scn.sap.com/thread/3221727

Regards,