SAP Knowledge Base Article - Public

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

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

  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:
  3. Besides the recommendations from the SAP Help page above, implement the following enhancements on your BW or BW/4HANA system:
  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: 

See Also

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

Product

SAP Analytics Cloud 1.0