Design Studio 1.6 sp2 reloadData() gets wrong data

[emrys_tx]

I am using Design Studio 1.6 SP2 to create a dashboard. It has 26 charts total (not all are shown at the same time). Each chart has as separate data source but data sources are initialized until they are actually required.

Using Time Out 2.0 - the SDK component - I refresh the initialized data sources every 15 minutes. I have one JavaScript function which handles the refresh which is called when the timer fires. I also have an icon which allows users to manually refresh the data at any time which uses the same JavaScript function: serviceRefresh().

Over time, some of the data sources start to falsely increase. I can look at the invocation of the chart that is periodically refreshing and compare it to an invocation I just ran and the count is different. For example, in the auto-refreshing invocation, the count is 24.8 but if I open a new invocation of the report that count is 23.8.

The offending data sources are BEx queries, at least the ones I have observed.

I put in safeguards to prevent the meat of serviceRefresh() from being executed more than once simultaneously. serviceRefresh() starts and ends like this:

if ( ! refreshing ) {

refreshing = true;

...

refreshing = false;

} // end if not refreshing

The basic processing for a single data source is:

if ( DS.isInitialized() ) {

DS.refreshData();

} // end if

Has anyone else seen this issue?

Jeff

[MustafaBensan]

Hi Jeff,

Could you provide some more clarity about the following:

1) What you mean by "some of the data sources start to falsely increase"?

2) When you say "the count is different" what do you mean by "count"? Do you have a key figure based on count in the BEx Query?

3) It might be helpful if you provided the entire script code for the serviceRefresh() function.

Regards,

Mustafa.

[emrys_tx]

Fahad,

My BEx query does not have a Cells tab.

nocellstab.png

Does that mean that this will not be the issue for me?

Jeff

[emrys_tx]

Fahad,

Sorry for the delay in responding.

It is a text component bound to a value in a data source.

bounddata.png

Jeff

[former_member197738]

No worries Jeff.

Try checking if the bex query is "cell-definition' (every cell is calculated) or in your case the text component bound to that value cell. If that's the case than most likely thats what is the issue is.

I had same bex behavior as your mentioned in you scenario with my x-client. I don't recall the tweak i did with code on Design Studio side but thats where i applied the fix. I can certainly try to recall.

Basically each time we fire bex via reload/refresh, 'cell-definition' value changes, that should not be the case.

[emrys_tx]

Fahad,

I have looked in the Data Source initial view, the bind definition in the text component and the BEx query and cannot find anything that looks like 'cell definition'. Where would I find that?

Jeff

[former_member197738]

Please check for "Cell Tab" in bex.

-Fahad

[former_member197738]

HI Jeff - Is the query plugged-in to DS is a 'cell definition query'?

Regards,

Fahad

[emrys_tx]

opened issue 358946 / 2017 with SAP support