Skip to Content
avatar image
Former Member

Recursive Bex query

Hi,

I have a requirement for BW query, in row i have a material M1 and in column i have KF 1 and KF2, where KF1 is a keyfigure for M1 and KF2 is a keyfigure for M2 wich is also a material but referenced as navigational attribute of M1 (M1__M2)

Material         KF1       KF2

M1              10          12

Any ideas on how to achieve this ?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2017 at 02:42 PM

    This is called Transitive attribute.

    You will find quite a few posts on the subject. Composite provider seems to be the way to go on a BW on Hana. Otherwise you will have to materialize the link in your infoProvider (see here).

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded