on 03-27-2017 10:25 AM
Hello Guys
I'm still a bit new to BW.
I need to get the values of all the levels in a hierarchy infoobject in the DSO and map them to separate infoobjects in the cube (transformation). So in the end you would have 10 infoobjects, Level 1 to Level 10, each containing that level's value. Is there a way I can get each level's value in the rule routine?
Example output:
Level1 (Continent) = US
Level2 (State) = Arizona
Level3 (City) = Phoenix
etc.
Thanks
Antonette
Hi,
so you want to create a flat structure of the hierarchy.
I think you can add The 10 levels as attributes to your infoobject of your hierarchy.
you can create a load from the infoobject to itself or if you want from your datasourse of the hierarchy and fill the attributes via ABAP coding.
You can add the attributes to all the cubes/dso's like you want where you have transactional data for the infoobject-hierarchy.
Grtz
Koen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.