on 09-08-2008 2:46 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I do not believe you can do transformations on Hierarchies yet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.