Question Re: Hierarchy Issue in Technology Q&A

Hierarchy Issue

Former Member — Wed, 16 Aug 2006 21:22:18 GMT

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

Re: Hierarchy Issue

Former Member — Wed, 16 Aug 2006 21:27:02 GMT

Hi-

Are you getting Data in RSA3?

Thanks,

Re: Hierarchy Issue

Former Member — Wed, 16 Aug 2006 22:28:18 GMT

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

Re: Hierarchy Issue

Former Member — Thu, 17 Aug 2006 13:04:26 GMT

Hello CP and Vijay

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

thanks

sampath

Re: Hierarchy Issue

Former Member — Fri, 18 Aug 2006 00:03:13 GMT

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.

Re: Hierarchy Issue

Former Member — Fri, 18 Aug 2006 02:16:24 GMT

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

Re: Hierarchy Issue

Former Member — Fri, 18 Aug 2006 04:57:38 GMT

Hi,

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

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

Regards,

BRB

Re: Hierarchy Issue

Former Member — Fri, 18 Aug 2006 20:04:59 GMT

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

Re: Hierarchy Issue

Former Member — Tue, 22 Aug 2006 14:58:50 GMT

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.

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:00:17 GMT

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

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:03:04 GMT

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 ???

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:08:37 GMT

Hello Kamal

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

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:27:16 GMT

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

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:56:23 GMT

Hello Kamal

I checked but my hierarchy is not available.

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 19:59:48 GMT

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 ??

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 20:00:04 GMT

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

Re: Hierarchy Issue

Former Member — Wed, 20 Sep 2006 20:07:06 GMT

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....

Re: Hierarchy Issue

Former Member — Wed, 27 Sep 2006 20:28:15 GMT

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