3339057 - Tips for using the optimized design experience for BW Live Data Connection scenarios in SAP Analytics Cloud (SAC)

• 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. 

• SAP Analytics Cloud (Enterprise)

Configuration

1. 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?
    
2. Implement the enhancements suggested in:
   • SAP Help: Backwards Compatibility Guidance for Using Optimized Story Experience with SAP BW
      
3. Besides the recommendations from the SAP Help page above, implement the following enhancements on your BW or BW/4HANA system:
   • 2933299 - InA: Reduce size of attribute metadata
   • 2946301 - InA: Reduce size of attribute metadata II
   • 3221225 - InA: Persisted InA support - Part VIII 
   • 3231479 - InA: Persisted InA support - Part IX  
   • 3283848 - InA: Persisted InA support - Part X 
      
4. 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

• 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?

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