Skip to Content
0
Feb 14, 2011 at 05:55 PM

How to derive hierarchycal dimension from characteristic hierarchy BW 3.5

56 Views

Dear Experts,

I have the requirement to resolve a characteristics hierarchy into a hierarchy modelled in a dimension.

In detail:

characteristic CHAR00 with hierarchy CHARHIER

I have to add to the cube the characteristics

HIELEV00

HIELEV01

HIELEV02

HIELEV03

...

They are all representing the levels of the hierarchy CHARHIER.

I'm thinking about something like a function module that returns the level nodes of the hierachy to every single chrateristic (leaf)

Best regards

Gregor