Question Re: Tabstrip performance Analytics Designer SAP Analytics Cloud in Technology Q&A

Tabstrip performance Analytics Designer SAP Analytics Cloud

mario_11 — Fri, 18 Jun 2021 07:08:51 GMT

Dear Team,

While using tabstrip component in Analytics Designer , is it possible to not load the data sources of other tabs through scripting while the 1st tab is getting loaded .

This is in regards to the performance of the dashboard . At the moment when I check the performance of the dashboard , all the tabs and the corresponding data sources are getting loaded simultaneously.

BR,

A Singh

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

saurabh_sonawane — Fri, 18 Jun 2021 13:04:43 GMT

Hi,

Click on file -> Analytics application settings,

Thanks,

Saurabh S.

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

mario_11 — Fri, 18 Jun 2021 13:08:37 GMT

Hi Saurabh,

I know this setting. But this is only for widgets . I am talk about data sources.

So until and unless I click on the other tabs , the data sources of those widgets should not be initialized .

Kind Regards,

A Singh

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

saurabh_sonawane — Mon, 21 Jun 2021 14:55:12 GMT

Hi,

please try the below code = onInitialization funcation

Application.setRefreshPaused([Chart_1.getDataSource()],true);

and write the below code onClick of tab trip 2

Application.setRefreshPaused([Chart_1.getDataSource()],false); Application.refreshData([Chart_1.getDataSource()]);

Thanks,

Saurabh S.

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

avsalynin — Thu, 01 Jul 2021 09:08:09 GMT

saurabh.sonawane will this work with BW Live?

My example: I have 5 Bex queries. The dashboard opens with the transfer of parameters through the link from another dashboard.

with Application.setRefreshPaused([ds1,ds2,ds3],true) the dashboard is initialized around 20-25 sec

but, when i physically delete 3 Bex then immediately - 10 sec.

Is it possible do not load data sources on initialization?

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

Bob0001 — Thu, 01 Jul 2021 11:02:41 GMT

Load invisible widgets in background (background loading) and pause-refresh are two different features which can be used to tweak the performance of your app.

Background loading delays the initialization of the complete widget. However if you access the widget from the onInitialization script, the script will wait for each widget to be loaded. So you better not touch them there.

Pause-refresh disables server roundtrips for those widgets. You should enable this from the builder panel of the widget which you do not need to display on startup. Setting it in onInititalization is too late as they are already loaded the data.

Please read the performance recommendations in the developer handbook for more details.

Hopefully we can automate some of these common use cases in future.

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

avsalynin — Mon, 05 Jul 2021 10:26:39 GMT

bob.meincke is it possible do not load data sources on initialization?

Like it was in Lumira - "load ds in script"

Since now all bex are loaded in AD, when the application is initialized, even if the tables / charts for these bex are hidden, right?

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

Bob0001 — Mon, 05 Jul 2021 10:34:24 GMT

It is possible (although it does not work 100% identical) using the checkbox "Pause Data Refresh" in the builder panel. At runtime call DataSource#setRefreshPaused(false)

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

avsalynin — Mon, 05 Jul 2021 10:52:51 GMT

Unfortunately it is not so:(

The initialization time of the dashboard with DataSource#setRefreshPaused(false) does not change.

Improves only when bex with parameters are physically removed from the dashboard.

DS: BW (Live)

SAC: 2021.7.12 (Client), 2021.7.7 (Server)

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

Bob0001 — Mon, 05 Jul 2021 11:08:51 GMT

avsalynin please create an incident for SAP then.

Re: Tabstrip performance Analytics Designer SAP Analytics Cloud

Alex_B — Mon, 20 Jun 2022 09:43:06 GMT

Hi avsalynin,

I have the same issue. Do you already have any solutions?

BR Alex