SAP Analytics applications - Possibility of pausing the table update when using the navigation panel

[larissa_martins]

Hi All,

I would like to know if there is a way to pause the update when we are using the navigation panel in SAC, because every new measure or dimension we add to the table, it will be updated, so depending on how many fields we need to add/remove, it will take a long time.

I know it's possible to add a script to pause it, but I couldn't activate it after making all the changes.

I also know this is possible in Excel/Analysis for Office, so I'd like to confirm if it's also possible in SAC (classic mode)

navigation-panel.png

I really appreacite your answer on this question.

Thank you in advance.

Larissa Martins

[eeddggaarr · Accepted solution]

Hi Larissa,

before you open navigation panel use code below to deactivate update of table 1:

Table_1.getDataSource().setRefreshPaused(true);

let user open navigatoin panel with e.g. a button with:

Table_1.openNavigationPanel();

with open navigation panel you can change settings on this panel without updating your table.
an additional button could trigger update of your table and close navigation panel:

Table_1.getDataSource().setRefreshPaused(false);
Table_1.closeNavigationPanel();

br
edgar

[larissa_martins · Accepted solution]

Hi Edgar,

[larissa_martins · Accepted solution]

Hi Edgar, Thank you!

[GregBotticchio]

Hello,

Please, would this also apply to the SAC Story Table in optimised mode?

Thanks in advance!

Best regards,

GB