Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

BPC EPM Find Hidden Hierarchies in the Excel Sheet

Former Member

on ‎2019 Jul 12 10:11 AM

0 Likes
586

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.

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
former_member186338
Active Contributor
‎2019 Jul 12 12:33 PM
0 Likes

Sorry, but is something not clear in my answer?

View Entire Topic
former_member186338
Active Contributor
‎2019 Jul 12 10:20 AM
0 Likes

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!

Show replies
Show replies
Former Member
‎2019 Jul 12 2:03 PM
0 Likes

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.

Ask a Question