Using hierarchies in transformations

[Former Member]

Experts,

I have a hierarchy created on a info object "Pricing Condition". Is there a way I can use this hierarchy in my transformations and when I load certain key figures I want the summing to happen on certain hierarchy nodes. Is this possible?

Thanks

Yashu Raj

[desgallagher]

Hi Yashu,

Hierarchies are not supported by DTP and Transformation in BI 7.0

you have still to use the old functionality.

In BI 7.0 the only difference is that now characteristics with a

length > 32 are supported for hierarchies but only via transfer

method PSA. See note 1012569.

In the next BI release (follow on from BI 7.0) hierarchies are

fully supported by DTP and Transformation but only with the

transfer method PSA.

Remote hierarchies will also be possible, that means the

hierarchy data can be retrieved directly during query run time

from the extractor.

Regards,

Des Gallagher.

[Former Member]

Hi Yashu,

it is possible to access a hierachy by the Infoobject H* table. First you look into table RSHIEDIR using a statement like this:

  SELECT SINGLE hieid
    FROM rshiedir
    INTO lv_hierid
   WHERE hienm = p_source
     AND version = p_vers
     AND dateto >= sy-datum
     AND datefrom <= sy-datum.

p_source is the name of your hierarchy

p_vers the version (if applicable, may be 0)

You need the hierarchy ID to select the correct Hierarchy in the H table of the Infoobject.

I would suggest to load the hierarchy into a local table in the start routine, and then collect the data you need to achieve your goal.

Maybe this helps.

Kind regards,

Jürgen

[Former Member]

I do not believe you can do transformations on Hierarchies yet.