Skip to Content
0

Hierarchy Values in the Report Output

Nov 16, 2017 at 03:33 PM

38

avatar image
Former Member

Hi Experts,

I have a workbook assigned with multiple queries for different tabs, In one of the tab i want the values which are restricted in the filtered window for a characteristic info object to be displayed in the workbook output. The restricted values are a combination of both single values and hierarchy node values, I tried with the Text element but in the output it is showing as complex selection, I think this is because of the hierarchy node values in the restriction. So how do i come up with a solution for this so that the restricted hierarchy node values to be displayed in the workbook output. Any inputs are highly appreciated. Thank you all in advance.

Regards,

C.

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

1 Answer

Koen Hesters Nov 24, 2017 at 03:15 PM
0

Hi,

create a bex query based upon your hierarchy. set a variable on it to be able to restrict it while prompting

secondly change all other queries which is used in your workbook and are using that hierarchy. you set a variable replacement path on your hierarchy-infoobject as "replace from query".

Finally in your workbook add the query of the hierarchy and I hope this will work out great for you.

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded