Symptom
- You have a BW or BW/4HANA live data connection in SAP Analytics Cloud (SAC) and you would like to use the optimized story experience (OSE) / optimized design experience (ODE) (Unified story).
- Mandatory prerequisites (SAP Notes) are required on the BW and BW/4HANA server.
Environment
- SAP Analytics Cloud (Enterprise)
Cause
Configuration
Resolution
- In general, please implement the support package suggested in:
SAP Note 2541557 - SAP Analytics Cloud with BW live connection - Which BW support package is recommended?
- Implement the enhancements suggested in:
- Besides the recommendations from the SAP Help page above, implement the following enhancements on your BW or BW/4HANA system:
- To make sure you have enabled the necessary features for the optimized design experience, perform the following actions during the live data model creation:
- Under Model "Preferences" > "Data and Performance", enable the options: "Optimized Story Building Performance" and "Reduce BW Query Metadata".
- For BW/4HANA queries, enable "Optimize Performance for Two-Structure Queries".*
* Notice that it's important to be aware of the impacts when using the "Optimize Performance for Two-Structure Queries" option:
-
- SAP Help: Optimizing Query Performance
See Also
- SAP Help: Optimized Story Experience Improvements
- SAP Help: Optimized Story Experience Restrictions
- The New Optimized Story Experience: The Unification of Story and Analytic Application is now Available with QRC2/2023 Release
- Unifying Story and Analytic Application with the New Optimized Story Experience in SAP Analytics Cloud
- 2541557 - SAP Analytics Cloud with BW live connection - Which BW support package is recommended?
Keywords
The feature requested by the client using BW InA is not implemented, SAC, BW, Optimized Mode, Performance, hints, best practice, Analytics Cloud, INA, 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, optimized story experience (OSE) optimized design experience ODE Unified story BW live connection InA: Persisted InA support attribute metadata Optimized Story Building Performance and Reduce BW Query Metadata , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , LOD-ANA-UNS-DVP , Unified Story Developer Issues , LOD-ANA-UNS-DSG , Unified Story Designer Issues , LOD-ANA-UNS , SAC Unified Story (Story 2.0) main component. , LOD-ANA-TAB , Table , LOD-ANA-DES , Story Design & Visualizations , Problem