Question Re: SAC Analytic Application - Wait until data fully loaded in Technology Q&A

SAC Analytic Application - Wait until data fully loaded

sanpe — Thu, 17 Jun 2021 13:12:23 GMT

Hello folks,

I'm wondering if there is a way how to determine with a code to wait/pause until the widgets are fully loaded and then continue?

In more detail: I want to run at the end of my function the code "Application.hideBusyIndicator()", but for this I have to determine somehow when the load is finished.

Any hints/suggestions would be appreciated.

Thanks.

Peter

Re: SAC Analytic Application - Wait until data fully loaded

avsalynin — Tue, 06 Jul 2021 13:21:28 GMT

What will be incorrect if you do something like this?

Application.showBusyIndicator('Data is loading'); 
Table_1.getDataSource().getResultSet(); // one || more sources
Application.hideBusyIndicator();

Re: SAC Analytic Application - Wait until data fully loaded

sanpe — Wed, 07 Jul 2021 06:11:15 GMT

Hi Aleksey,
thanks for your reply!

My dataset in quite large (with some extra calculations, exception aggregations, etc... in the live model). The problem is, that the code is quicker/finishes earlier than the widgets are fully loaded.

The impact is that the 'busyIndicator' is hidden earlier than expected.

Re: SAC Analytic Application - Wait until data fully loaded

avsalynin — Wed, 07 Jul 2021 06:51:59 GMT

Then maybe add check for isEmpty() for datasource before the hideBusyIndicator()?

Re: SAC Analytic Application - Wait until data fully loaded

Shwareb — Wed, 13 Apr 2022 21:36:12 GMT

Hi Peter,

Have you found a soluation for this? I have a similar requirments but the busy indicator disapear before the widgets is fully loaded.

Re: SAC Analytic Application - Wait until data fully loaded

JBARLOW — Thu, 14 Apr 2022 11:40:33 GMT

In the past I've had to estimate load times - not ideal but.

Also used stuff like checking result sets and using timers to delay things.

Application.showBusyIndicator("Loading");
var LEN = Chart_1.getDataSource().getResultSet().length;
if(LEN>0)
	{HIDE_LOAD.start(1);}

//HIDE_LOAD  contains the code ---
Application.hideBusyIndicator();

Re: SAC Analytic Application - Wait until data fully loaded

Bob0001 — Tue, 19 Apr 2022 07:45:50 GMT

Hi sanpe,

The background is that widget refresh operations are delayed and bundled at the end of the script, but this means any call hiding the loading indicator before will be too early. Have you tried the automatic loading indicator yet? It is exactly build for such cases (I admit it might have some weaknesses still).

Depending on your scenario you could try enforcing the update during the script using Application.refreshData and passing the array of data sources to refresh (important!). But I would not recommend this as a general purpose apporach as it by-passes the builtin optimzation mechanisms.

Re: SAC Analytic Application - Wait until data fully loaded

rafal_skorupa1 — Tue, 21 Jun 2022 14:34:41 GMT

Hi Bob

Is there any document that explains how this bundling works (Live connection BW)?

I would like to complete simple scenario:

1.Add dimension to table

2.Read resultset to get member Id of a new dimension

It surprised me that read resultset is not waiting for the previous action on table to finish and it returns incomplete data...

even calling getDataSource().refreshdata after every table modification doesn't help.

The only workaround was to add a loop between action 1 and 2 that delays things by some artificial operations-which is super ugly solution...

Regards

Rafa

Re: SAC Analytic Application - Wait until data fully loaded

Bob0001 — Tue, 21 Jun 2022 19:13:29 GMT

Hi rafal.skorupa, I think it is outlined to some degree in the performance chapter of the Analytics Designer handbook. In your simple case (not using background loading or pause refresh) adding dimension to table is not loading the data immediately. This allows you to add or remove more dimensions/measures in the same script without the overhead of loading the result on each step. Reading the result set then does trigger the load and waits until it completed.

Re: SAC Analytic Application - Wait until data fully loaded

rafal_skorupa1 — Tue, 05 Jul 2022 14:16:10 GMT

Hi bob.meincke

More detailed scenario I described here:

https://answers.sap.com/questions/13665522/live-connection-resultset-issue.html

Is it really by design like this?

regards

Rafał

Re: SAC Analytic Application - Wait until data fully loaded

Bob0001 — Tue, 05 Jul 2022 14:52:54 GMT

Commented on the linked question, where it seems to not work as I explained it above.

Re: SAC Analytic Application - Wait until data fully loaded

adamban — Mon, 25 Sep 2023 05:07:49 GMT

Hi Bob,

The automatic "Loading Indicator Settings" in Global Settings only activates when first loading the story.

How do we trigger this when the user makes a change in a table, & all calculated members are calculating and refreshing?

I have an issue where users are changing data in a table & clicking a data action before calculated members have finished updating, causing data issues.

Re: SAC Analytic Application - Wait until data fully loaded

Bob0001 — Mon, 25 Sep 2023 15:16:09 GMT

I think it would be good if you could explain the scenario in a bit more detail. This could help others to come up with an idea.