Question Re: SAC Script api: can I work with story filter by using scripting in Technology Q&A

SAC Script api: can I work with story filter by using scripting

kumkej — Wed, 26 Jul 2023 09:22:37 GMT

I have the problem that I would like to access the global story filters of the story via scripting. Do I have the possibility to read these values via a get function and can I also set the filters via a function? ....getDataSource().getDimensionFilters(...) is not even showing me the selected filter values of the story filter.

Thank you for your help

Re: SAC Script api: can I work with story filter by using scripting

CasCriel79 — Wed, 26 Jul 2023 09:33:26 GMT

Hi, I think this is not possible due to the fact that you are working in a specific page (at least when we are talking about the unified story). However, I noticed that SAP put this in the roadmap for the next quarter. This will open a lot of new opportunities! 🙂

Re: SAC Script api: can I work with story filter by using scripting

N1kh1l — Wed, 26 Jul 2023 11:52:07 GMT

kumkej

kumkejIn responsive layouts the API's return blank but if its a canvas layout ...getDataSource().getDimensionFilters(...) should return the filter values.

Hope this helps

Nikhil

Re: SAC Script api: can I work with story filter by using scripting

William_Yu1 — Wed, 26 Jul 2023 14:04:05 GMT

Right, 2023 QRC3 update will provide the exact API you need to get and set value for story filter .

Re: SAC Script api: can I work with story filter by using scripting

brian_jespersen — Mon, 21 Aug 2023 08:33:24 GMT

What is the name of this API and how to use it?

Re: SAC Script api: can I work with story filter by using scripting

N1kh1l — Mon, 21 Aug 2023 08:50:51 GMT

brian.jespersen

Its discussed in below blog, Chapter Script API for Story Filter Bar

https://blogs.sap.com/2023/06/22/whats-new-in-sap-analytics-cloud-release-2023.13/#3

Nikhil

Re: SAC Script api: can I work with story filter by using scripting

tablespace — Sat, 25 Nov 2023 18:41:55 GMT

kumkej Until now it´s not possible to read the selected values from an Story Filter directly. But, you can use a workaround based on the cascading filter effect of story filters.

1. Create your Story Filter and ensure the cascading effect is enabled

2. Create a Input Control (IPC) for the same DIM on the page you would like to integrate the Script. (You can disable all links of the IPC to other widgets and you can hide the IPC, because it is only a "helper" IPC.

3. Now you´re able to read the selections via script from the Story Filter via the IPC, because there are the same entries selected, caused by the cascading effect of the Story Filter.

Example:

//Story Filter on DIM "Date"
//InputControl(IPC) on DIM "Date" as well - now you can read the Date selections from your Story Filter

var sel_date = IPC_1.getInputControlDataSource().getActiveSelectedMembers();
console.log("sel_date");
console.log(sel_date);

Re: SAC Script api: can I work with story filter by using scripting

Sebastian_Gesiarz — Thu, 30 Nov 2023 13:51:41 GMT

I can confirm the below works well to fetch the selection;

var selectedFilterValues = Application.getFileDataSource("MODELID").getDimensionFilters("DIMENSIONID");

Re: SAC Script api: can I work with story filter by using scripting

eeddggaarr — Thu, 07 Dec 2023 09:42:53 GMT

hi,
if you would like to get filter values from linked analysis please vote for this improvement request.

br
edgar

Re: SAC Script api: can I work with story filter by using...

stefan_dufter — Wed, 31 Jul 2024 09:02:04 GMT

try this:

var modelID="Cl7s7e1rj7i8amn7vo60oqj40d";     // your model id
var dimensionID = "0PROFIT_CTR";              // your filter dimension

var selectedFilterValues = Application.getFileDataSource(modelID).getDimensionFilters(dimensionID);
console.log(selectedFilterValues);

Re: SAC Script api: can I work with story filter by using...

stefan_dufter — Wed, 31 Jul 2024 09:05:51 GMT

ups sorry, didn't read the other answers first...