SAP Knowledge Base Article - Public

2855559 - Checkpoints: Performance issues related to SAP Analytics Cloud (SAC) for Planning Process

Symptom

Poor performance in SAP Analytics Cloud (SAC) related to Planning Functions

Environment

  • SAP Analytics Cloud 

Resolution

  1. Quick Wins:
    1. Refresh Browser Cache:
      1. Press F12 on the keyboard or right click to select the "Inspect" option.
      2. Go to the "Refresh" button, and you will see 3 selections.
      3. Choose "Empty Cache and Hard reload"

    2. Make sure the tips in "Best Practices for Performance" has been applied.
       
  2. Bench Mark Tool: 
    1. Go to Menu- System - Performance - Bench Mark Tool
    2. Run the the client test in the affected machines
    3. Run the the network test in the affected machines
    4. compare with other users' machines and see if the performance issue is machine/network related. 
       
  3. Model:
    1. Check if "Optimize Story Building Performance" is enabled in the Model Preferences under Data and Performance.
       
  4. Version
    1. Check if you can delete the private versions:  open model -> Planning and time range -> Delete Private Versions.
       
  5. Dimensions:
    1. Check if Data Access Control on the dimension level for all users
    2. Dimension Hierarchy:
      1. Check if the performance degradation only occurs when the story uses parent child hierarchies.
        And the performance gets better once you change it to "Flat Presentation".
         
  6. Input data:
    1. Zero Value
      1. Check if zero value is pre-seeded into a very large number of records (cells/facts) in the model. In this case, input data will cause very large queries on the backend.
      2. If zero values can be removed, you can follow the instruction in KBA 3102951 to delete them.
         
  7. Data Action:
    1. Main considerations:
      1. Number of records of target version
      2. Intermediate & calculated result of script processing
        1. Number of Dimensions in the model
        2. Number of member IDs of each dimensions
        3. Processing related to planning procedures:
          1. data locking
          2. validation rules
          3. currency conversion
          4. audit recording
    2. 3261092 What does "Preparing to Execute" in the data action log mean in SAP Analytics Cloud (SAC)
       
  8. Data size
    Planning on large versions can affect performance, so you can recommend a limit on the initial version size for planning.
    A warning appears if users exceed this limit while creating a private version or starting to edit a public version.
     
    1. Check if the data size is within the SAC limitations: System Sizing, Tuning, and Limits.
    2. General approach to reduce the amount of data:
      1. Apply more stricter filters.
      2. Work with different models for different personas.
    3. By default, every planning version in a planning model has a default limit set to 5 million facts that can be adjusted.
      1. Setting Up Model Preferences (Size Limits for Planning Performance).
    4. Optimize Planning Models Using the Planning Area.
      See the following help article and blog for more information:
      1. Optimize Planning Models Using the Planning Area
      2. Introduction to the Planning Area Optimization for SAP Analytics Cloud

  9. Story:
    1. Avoid "Cascading Effect" setting which is on by default in filters.
      1. 2652024 - Significant performance decrease when using filters in an SAP Analytics Cloud (SAC) Story
    2. Enable Optimized Presentation Table (suited for large tables):
      1. Table Features and Limitations.
    3. Disable the thresholds on cross calculations.
    4. Switch to the condensed row height layout via Styling (the icon right next to "Builder") -> Table Properties -> Row Height -> Super Condensed.
    5. Check if the performance can be better when using the right click -> Table Function ->  "Ignore Data Locks" on a table.
       
  10. Network Trace:
    1. 2280022 - How to collect an HTTP archive (HAR) file (Chrome developer tools network trace) in SAP Analytics Cloud
       
  11. Performance Trace:
    1. Right click - Inspect.
    2. Go to performance tab.
    3. Click the record button.
    4. Reproduce the issue.
    5. Stop the recording.
    6. Save the trace profile.
    7. Compress (zip) and attach into the SAP case.
       
  12. Submit a case to SAP: 
    1. Information needed:
      1. SAC Tenant link.
      2. SAC Model link.
      3. SAC Story link or SAC Data Action link
      4. Steps to reproduce.
         
    2. Components:
      1. HAN-DB-ENG-MDS [SAP HANA Multidimensional Services MDS / InA].
      2. HAN-DB-EPM [SAP HANA Planning and Simulation Platform].
      3. LOD-ANA-TAB if related to table in the story.
      4. LOD-ANA-PL-[Sub Components] if it is related to planning functions.

    See Also

    • 2831999 - SAC: User-specific performance issue when updating data in the story
    • 2652024 - Significant Performance decrease when using filters in SAP Analytics Cloud (SAC) Story
    • 2511489 - Troubleshooting performance issues in SAP Analytics Cloud (Collective KBA)
    • 2327454 - Low performance occurs in tables / grid and other areas of SAP Analytics Cloud
    • 2699872 - How to improve performance in the SAP Analytics Cloud (SAC) app for iOS

    Keywords

    SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,  observed that the Browse > Models is missing in our SAC tenant. Has there been any change in the options with the recent updates, The operation on the version failed, most likely because it is too large. sap analytics cloud, analytics cloud, cloud analytics, analytics, sac, sap analytics cloud for planning, fp&a, collaborative planning, enterprise planning, extended planning, xP&A, extended planning and analysis, financial planning and analysis, connected planning, integrated planning, workforce planning, headcount planning, allocations, value driver tree, VDT, data action, predictive forecasting, smart predict, planning applications, planning model, advanced formulas, strategic planning, Profit and Loss Planning, P&L planning, bottom-up planning, top-down planning, currency conversion, version management, fp&a, predictive analytics, operational plan(s)(ning), financial planning and analysis, planning tools, integrated business planning, xp&a, integrated planning, collaborative planning, planning model (s), connected planning, enterprise planning, budgeting and forecasting software, enterprise planning, planning and forecasting, planning budgeting and forecasting, planning and analysis, enterprise planning software, financial planning and forecasting, sap analytics cloud planning, predictive planning, driver based models, what if planning, enterprise planning cloud, cloud fp&a, Enterprise Planning, Planning, analysis, budgeting, and prediction in one solution, Embedded business intelligence and predictive analytics, Integration with SAP S/4HANA , KBA , using script api has low performance , sac data action execution using , sac_data action execution using script a , multiple users attempt to plan , sac test system when , significant performance issues on , LOD-ANA-PL , Planning , LOD-ANA-TAB , Table , LOD-ANA-CC , SAC Currency conversion , Problem

    Product

    SAP Analytics Cloud 1.0