Hierarchy Issue

[Former Member]

Hello Friends

I am trying to load account hierarchy from R/3 system to BW system. In the infopackage when i click the available hierarchy in OLTP system i am not able to see the one which i want to select and others are showing up. This hieraechy is available in R/3 system. Any help is appreciated.

thanks

sampath

[Former Member]

Hello Kamal

Thanks for your helpful answer. As per your advice i checked and it is not available in top node. I awarded points for your answer.

sampath

[Former Member]

Kamal if i select the option No end nodes i can see my hierarchy.

[Former Member]

give your group name to your functional guys and ask if its part of a parent node....based on that you can load the parent node and in the report you can select the child node (the hierarchy which you are looking for) and restrict it to a row...if you are not able to see the group when you select 'top nodes only' it means that the hierarchy which you are looking for is part of a parent node....and in the infopackage you will only see the top nodes

assign points if it helps....

[Former Member]

Hello Kamal

I checked but my hierarchy is not available.

[Former Member]

check if you can see your hierarchy when you put in 'all nodes'..

my guess is that the hierarchy which you are looking for is a child node of an existing hierarchy ....

is this for PCA ??

[Former Member]

Hello Kamal

Thanks for the response. We can see the list of hierarchies for a datasource in RSA6.

[Former Member]

can you goto tcode ...kdh3 and select top nodes only and see if your hierarchy is available there...

[Former Member]

Hello Friends

Datasource name is "0ACCOUNT_0109_HIER" and it has several hierarchies. I am loading other hierarchies from this source regularly but only one is not showing up in RSA3 and in the infopackage but R/3 says it is available. Do we need any additional set up to bring this. Any help is appreciated.

thanks

sampath

[Former Member]

it could be possible that the hierarchy which you are looking at is a part of a parent hierarchy....

in R/3 what tcode are you looking at the group ???

[Former Member]

Hello Vijay, Gimmo and BRB

thanks for the response. This Hierarchy is the old one but not loaded into BW. Now the user wants to use this hierarchy. It is available in R/3 system. I checked in RSA3 also but it is not showing in RSA3. Do we have to do any setup in R/3 system in order to get this hierarchy.

thanks

sampath

[Former Member]

Hi Sampath

Check RSA5 in R/3 side for your Hierarchy if it is business content Heirarchy. If you find it there then go and install it to bring it in RSA6 and then replicate to BW.

[Former Member]

Hi,

Another thing is to make sure that the datasource is indeed meant for the accounts hierarchy. Different types of hierarchy requires different datasource. Please use BW07 in the source system to generate for the different types of hierarchies. Note this is meant for FISL sets. To view what the table the hierarchy is built on, go to GS03 and put in the hierarchy name. Take note of the table name.

Cheers,

Gim

[Former Member]

Hi,

Is that hierarchy created recently in R3 or how is it..?

If Yes ,is replication done or not yet ..?

Regards,

BRB

[Former Member]

Hello CP and Vijay

Thanks for your response. I already tried these options but not yet succeeded.

thanks

sampath

[Former Member]

Hello Sampath,

If the OLTP is not bringing the hierarchy means, I would go after R3 to insure that hierarchy really exists and name of the hierarchy before the refresh since if its present in R3 it should come out to BW.

[Former Member]

Hi-

Are you getting Data in RSA3?

Thanks,

CP

[Former Member]

Hello Dr Sampath,

There is a Refresh from OLTP option present in the Infopacakge which would refresh all the available hierarchy from R3.

Hope this helps.

Vijay