Skip to Content
0

Design Studio 1.6 sp2 reloadData() gets wrong data

Jul 19, 2017 at 07:46 PM

87

avatar image

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

10 |10000 characters needed characters left characters exceeded

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.

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Jeff White Jul 27, 2017 at 01:53 PM
0

opened issue 358946 / 2017 with SAP support

Share
10 |10000 characters needed characters left characters exceeded
Mohd Fahad Jul 31, 2017 at 04:13 PM
0

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

Regards,

Fahad

Share
10 |10000 characters needed characters left characters exceeded
Jeff White Sep 20, 2017 at 06:50 PM
0

Fahad,

Sorry for the delay in responding.

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

bounddata.png

Jeff


bounddata.png (25.2 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

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.

0

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

0

Please check for "Cell Tab" in bex.

-Fahad

4.png (55.7 kB)
0
Jeff White Sep 21, 2017 at 08:59 PM
0

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


nocellstab.png (81.7 kB)
Share
10 |10000 characters needed characters left characters exceeded