Skip to Content
0
Former Member
Apr 24, 2014 at 11:34 AM

Query not able to Retrieve Summary Level Member

26 Views

Dear all,

I have created a Planning application on BPC Netweaver 10.0.

I am trying to retrieve the Planning Data via BEx Query in Dashboard.


My Account dimension is hierarchical and I want the dashboard users to be able to select summary account when viewing the dashboard (Refer to Look.PNG)


However, the limitation is that only bottom level members are available in the list.



So I try to edit the query to summary level accounts available to choose from.

Query.PNG is my existing design where I can use the filter and prompt for values.

However, if I apply the setting in Query2.PNG, I can select SOME summary level account but the filter is not available anymore.

Is there anyway to allow users to choose summary account they would like to see?

Is the problem related to how the query was set in query designer? Why it drills down to bottom level automatically?

Thanks,

Winson


Attachments

Query2.PNG (100.5 kB)
Query.PNG (58.3 kB)
Look.PNG (36.9 kB)