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

[MK90]

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

[MK90]

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.

[MK90]

Hi william.yu ,

I recreated the scenario now also for other Composite/Provider/ Queries.

• In the Chart-Widget the Filters always behave the same - also for all other objects in there, like "use all masterdata" for navigation. That means there is no dependent filtering possible between the filters.
• The SAC Data Tab (see screenshot - bottom part), as well as the upper Part (BEx, AfO) behave like totally normal - as a standard query - with setting "only booked values for navigation".

What i question is the behavior of the Chart-Widgets Filters behavior:

• no matter what the query setting/infoobject/ composite setting is: the BW Live-Model setting (blue button that is only there for BW Models/Queries in Live Connection) does not take any effect, at all.
• The effect that is showing is, that ALL BOOKED VALUES are also displayed - as the button describes. BUT and that is the point, the functionality is NOT functioning dependetly on other member/filter settings that were done before -> that is why i get a long list on every object/filter again and again on a chart-widget filter, but I would expect a normal behavior like in the SAC Data tab , like in AO, like in BEx Query itself.

Is this now a "feature" or a "bug" ?

For me it feels like a bug, because I in my expectation I tell the query it should filter on the query settings I provided and in every tool that is used (BEx, AO, and even in SAC itself when generating a chart from the data tab) there is a normal dependend DOWNFILTERING happening, ALSO on the Filter Member Selection (see the screenshots bottom). This is NOT the case for the chart-widget filter - no matter what setting i will provide - the chart-widget filter does NOT do a cross-dependent downfiltering of selection values. Even if I tell the setting "Use query-defined member access" to use "only booked values for navigation".

I can technically understand that SAP does restrict the number of requests (by prohibiting many dependent filters and therefore requests) to the backend and that the widget-filter states probably are the ones which are requested once at that point, when asking the modeling initially for the chart creation. But when dealing with live models,i would expect another behavior, that the filters would also reload on every navigation step, since this is the standard behavior. (the query even has the reload on any navigation inside by standard).

[William_Yu]

I guess I know what you are looking for. I think you want a 'cascading effect' on widget filter. I'm afraid that's not the feature of SAC at the moment.

Cascading effect only exists for input contorl, story filter and data explorer( the data tab you referred to)， widget filter will basically show 'all booked members' or 'all members' according the setting in backend.