Chart Filter "Use query-defined member access" does not work on BW Live Connection to SAC

[MXK]

Hi,

i got a problem, that on a chart widget filter, there is no dependent filtering possible.

Only in SAP BW Live Connections based on a query the option "Use query-defined member access" comes available, that reads the query-specific and threrefore Infoobject specific setting how to read the member.

I am using "values as booked".

The query and therefore model behaves totally correct and downfilters without problems in the following:

- BEx query

- AfO

- even on the SAC data tab on a story

- Page filters

What does not work is the depedent filtering in a chart-widget. When going there to the Filters and putting a first selection it takes the query settings - alright.

The second filter does not provide the correct settings then and the query-defined member access function does not do anything. The same setting " only booked values for navigation" is ticked in the backend on all occasions (Composite, InfoObject, Query), but still the full list is displayed.

I am using a navigation attribute as Infoobject and an Infoobject for the filtering. one does not hold any data (navi attribute)

in the screenshots top - BEx/Afo and in the bottom SAC data tab - working as expected. Only the setting on live model "Use query-defined member access" on a chart widget makes problems.

Any ideas?

[William_Yu]

Hi mxmlnklngr,

From your screenshot, I see that the filter is showing unbookd member only as "show unbooked members' is OFF which is consistent to your backend setting 'only booked values for navigation'.

What's your expectation here? Or I misuunderstood you?

Best regards, William

[MXK]

Yes, as described- a dependent filter, cascading effect. I know it is possible on story filters, input controls, and data explorer as well as data analyzer. and it works there.

Why is SAP not implementing the function normally as expected? Why go a different path only in the chart-widgets? As consultant/customer i really have to question the functionality of the BW Live connection the, if no chart is able to navigate as booked... and the best of all there isnot possibility at all to oversteer the standard behavior. The model/query in the backend tells clearly to show selections on booked values - why is it not being reflected then ...?

All other things work as expected. In my opinion SAP did some shortcut development and forgot some stuff ... intentionally??

In this configuration/status i have to say SAC is a very immature tool. I have witnessed such flaws now in nearly every Live aspect and can say that with a BW Live connection SAC is really not usable after all, if developers (literally) have to guess every time how a chart/component etc. might behave.