SAP Knowledge Base Article - Public

3371121 - "Optimize Story Builder Performance" tables cannot be refreshed in SAP Analytics Cloud (SAC)

Symptom

When "Optimize Story Builder Performance" is selected for the BW live model, the refresh button in the toolbar of the story cannot refresh the table of this BW live model.
Only the refresh button in the table builder can refresh the table.

Environment

  • SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  1. Create a story.
  2. Add a table for a BW live model with "Optimize Story Builder Performance" selected.
  3. Make sure changes (for example, change the value for the input control or the filter)
  4. Click the Refresh button in the toolbar.
  5. The table is not updated according to the new setting.

Cause

This works as designed.

  • If the model is set to optimize story builder performance and user clicks on toolbar refresh, then as per the code, we do not refresh anything
  • We have a code check for expensive model (i.e. model with optimized story builder performance). If that is true, then we do not refresh anything. And this logic is been there since several years.
  • So once the user adds dimension input control and clicks on refresh button in toolbar, table is not getting updated because we are not refreshing.
  • Only way to refresh is through builder panel. And this is working as designed.

Resolution

Go to the warning message at the top of the Builder panel and click the refresh button there.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0