BPC EPM Find Hidden Hierarchies in the Excel Sheet

[former_member616449]

Hi experts,

How should I check the hierarchies of different cells in the excel sheet? As you can see from the screenshot, it only shows PARENTH1 without showing the other four, in which case all five hierarchies exist. Is there any way I can find out all the hierarchies without checking BW? Thank you.

[former_member186338]

Sorry, but is something not clear in my answer?

[former_member186338]

Looks like it's EPM issue!

Try to upgrade to latest EPM SP34

[former_member186338]

May be you have some synchronization issues!

Please provide full details about your BPC and BW version/SP

Also EPM SP?

[former_member616449]

BPC10.1 SP33

EPM 10.0 SP33

BW: Kernal 753 level: Patch 400

SAP_BASIS 740 Patch:0021

SAP_BW 740 Patch:0021

POASBC 810_731 Patch:0007

CPMBPC 810 Patch:0015

[former_member186338]

asd1351

BPC10.1 SP33 - meaningless!

EPM 10.0 SP33 - OK

SAP_BW 740 Patch:0021 - OK

CPMBPC 810 Patch:0015 - OK (SP16 - latest)

[former_member186338]

The provided picture means that this particular member has no hierarchy parent in hierarchies PARENTH2...6. Nothing strange, it's normal.

You can open BPC WEB administration and look on the dimension members!

[former_member616449]

Hi Vadim,

Here's another screenshot which will explain my question further. You can see from BW that account 100041 includes PARENTH1,

PARENTH8 and PARENT9, but it only shows PARENTH1 in the properties.