Skip to Content

Design Studio 1.6 sp2 reloadData() gets wrong data

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

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

4 Answers

  • Jul 27, 2017 at 01:53 PM

    opened issue 358946 / 2017 with SAP support

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 31, 2017 at 04:13 PM

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

    Regards,

    Fahad

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20, 2017 at 06:50 PM

    Fahad,

    Sorry for the delay in responding.

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

    bounddata.png

    Jeff

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 21, 2017 at 08:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded