A Problem with hierarchy

[Former Member]

Hi all,

I've a problem with hierarchie's leaves.

The client wants to see a leave under two differents nodes of the hierarchy.Indeed this leave was registred under Node A until 1999 and then under Node B (2000 to 2005).

In the report, he wants to see the sales of this leave under Node A and simultaneously the sales under Node B, maintening the hierarchy actived on the rows. The problem is that in the report the records of the sales are doubled and it not seems possible to see the "temporal split".

Instead it works fine if i do not use the hierarchy but two different infobjects for node and for leaves, but in this case i don't have the hierarchy in the report.

Can someone help me?

Thank U

Alex B

[Former Member]

Hi Rob,

I think that the problem is not the time dependence of the hierarchy, but the fact that the hierarchy is external, in that case in the dimension table you have only Dim - Sid and then in the Htable Sid - Node Id.

In other words you don't have the information about leaf (node A, Node B). Instead if you put entire hierarchy on the dimension table (internal hierarchy) you have this information Dim - Sid (node a) - Sid (node b) etc etc. I hope it's clear, if you want i'll send u by mail a screen paint of an internal hierarchy on the report.

Regards,

Alex B

[Former Member]

Alessandro,

thank you. I do understand the difference between the internal and the external hierarchy. (We had both scenarios in our blueprint) The reason we went with the external was because the client maintains this in his R/3 Org. Structure. Now having to flatten that into the cube seems silly to me. The data is available in the hierarchy (i can see the validity dates) but apparently cannot be used for display.

I'm just flustered, I always thought this was the whole point. And all people I've checked with had the same impression...

[Former Member]

Hi,

we have resolved (by using the suggest of Anil Kumar Sharma) the problem by writing one Abap program and One Abap routine on the update rules.

The Abap program read the H_Table of 0orgunit and organizes the records in another table (ZHUO) with this order:Mand - Code Sales Org - Datefrom - DateTo - Livel1 - Livel2 -..- Livel 7. Then we create Seven infoobjects and wrote a start routine thats loop at datapakage selects the record from the table created and put the codes of the livel 1 into the Infoobject 1, level 2 into the infoobject 2..etc etc. In this way i utilize an internal hierarchy but i have the complete history of the hierarchy. I dont think it is possible by using external hierarchies.

So in the report i see each node or subnote classified by level and i see the presences/absences (KF), done under node A or under node B, by viewing also the temporall split if i drill down 0calmonth.

I hope it is usefull

[Former Member]

Alessandro, Anil,

It was not the answer I was hoping for, but thank you for your suggestions. We also had thought of a similar approach but hoped that time dependent hierarchies could provide a simpler solution.

I am amazed this is not possible with time dependend hierarchies, I've checked with a lot of consultants and everybody seems to think it is possible (just that nobody ever seems to have used it with a client).

Is there anybody here from SAP who could tell me if this functionality exists or not.

[Former Member]

Hi,

You can try to play with link nodes:

http://help.sap.com/saphelp_nw04/helpdata/en/b3/fa3d3806136268e10000009b38f8cf/content.htm

Best regards,

Eugene

[Former Member]

I looked at that but it's not completely what I'm looking for. Here's the problem, I've got 2 locations (A and B) each location has 2 teams in it (A has 1 and 2, B has 3 and 4). Now from jan to march this is the situation, in april team 2 moves over to location B (A:1, B:2,3,4). In my report -that shows a full year- I need team 2 to display from jan to march in the report for location A (and zeroes as of april), in the report for location B I want so see zeroes for 2 up to april and then real values.

I can't use link nodes since I don't know beforehand what the changes will be (all this is based on 0orgunit hierarchy and maintained in the master data of R/3).

Any suggestions?

[Former Member]

Could anybody comment on this please?

[Former Member]

Hi,

To show the report as your reqirement , Do not take 'teams' as child node to 'Location' .Take them as two independent characterstics,i.e, take both of them as characterstics in Infocube. At the time of data loading ,the R/3 system has to findout the team for the location of the record.This will be done by customer exit.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Thank u,

but if i set my hierarchy time dependent, for exemple with a key date, i can see or the sales of that leave under Node A or the sales of that leave under Node B, but not together in the report.

Alex B

[Former Member]

Hi,

If you want the both sales under different Nodes in the report,i.e, sales done until 1999 needs to be displayed under node A and sales deone after 1999 needs to be displayed under node B , use that node(infoobject) in the transaction data. So there will be one more characterstic in infocobe to represent this NODE.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Anil,

I've got the same problem. Could you clarify your solution a bit more. I'm not sure what you mean.

Thanks

[Former Member]

Hi,

Have you seen the concept 'Time dependent hierarchy

structure'.

Take a look on the site:

http://help.sap.com/saphelp_bw32/helpdata/en/80/1a6702e07211d2acb80000e829fbfe/frameset.htm

With rgds,

Anil Kumar Sharma .P