Skip to Content
0

Recursive Bex query

Jan 05, 2017 at 03:15 PM

44

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Frédéric Cincet Jan 09, 2017 at 02:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded