dynamic filtering from script SAC

[former_member274397]

Hi Experts,

is it possible to dynamically filter charts in SAC Designer from script. which is known in Lumira as DS.setfilter().

with this dynamic filtering i am triying to leverage performance of Dashboard and use less charts

for example using a country dropdown list. When selecting 'Country X' chart should redisplay accordingly ..

regards

[ChenNee]

Hi!

With the Analytics Designer from SAP Analytics Cloud you are able to use getDataSource().setDimensionFilter() to control your widget.

see help for more info:
https://help.sap.com/doc/958d4c11261f42e992e8d01a4c0dde25/2021.6/en-US/index.html

For your case (to use less charts) I would even recommend that you use the DataExplorerConfiguration technical object to allow end users to slice and dice AND pin the results back into the app. This way you even allow configuration of dimensions. I have written a blog post on this:
https://blogs.sap.com/2021/03/17/analytics-designer-for-the-planning-process-when-is-the-right-time/

I hope it helps!

[ChenNee]

It is point #3 in the blog post.