Skip to Content
0
Former Member
Oct 23, 2015 at 02:51 PM

SAP BI 4 - BEx Query Hiearchy - Excluded Members and total not adjusted

40 Views

Hi,

I have a hierarchy which I am using with a SAP BW BICs connection.

I have add an input control to exclude certain members if needed but the total doesnt seem to adjust. For example,

UK = 150

- England = 50

- Wales = 50

- Scotland = 50

If I exclude Wales I still see 150 for UK. UK is not an actual member it is a node in the hiearchy so not sure why it isnt being re-calculated?

UK = 150

- England = 50

- Scotland = 50

Cheers