Loading Hierarchy in BPC NW 10.1 - Classic: Dimension members are not linked to hierarchy

[Former Member]

Hi everyone.

This may be very basic for most of you (sorry I’m new to BPC), but I have an issue with loading hierarchy structure from BW infoObject to BPC dimension.

I have loaded attributes (members & properties) in BPC as well as the text. I’m now trying to load the corresponding hierarchy from the same BW infoObject. While loading the hierarchy, I did specify the member ID, but NOT the level. When I select the hierarchy view, it only shows me the basic members. It does not show me the structure as it looks in BW. Is that means that I have to specify all level or what the right process to load hierarchy from BW is. Below is my transformation file and conversion file content.

Thanks everyone for your help.

[Former Member]

Hi Vadim,

Hier_name and NodeName are just excel sheets in the conversion file YFund_hier. Below is the screen of the selections. for member, I tried without member level, it did not work. I tried with different hierarchy member level , I did not work neither :

[former_member186338]

You have incorrect lines in *CONVERSION: Duplicated HIER_NAME! Is it clear?

The second line has to be:

NODENAME=YFUND_HIER.XLS!NODENAME

For hierarchy selection you can specify top node without level.

What do you have in Attribute selection? Please post full screenshots! The condition is also has to be shown!

[Former Member]

Hi John,

Please show the BW hierarchy as well......

Regards,

JP

[former_member186338]

First strange thing:

Double HIER_NAME??? May be second is NODENAME?

Second - please show the selection sreenshots!