Skip to Content
avatar image
Former Member

Using hierarchies in transformations

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 08, 2008 at 01:49 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 08, 2008 at 02:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2008 at 04:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded