6.2 Accessing Data from SAP Systems (cont) Flashcards
Data analyzer is ready to run for (3). They can be accessed directly in Select Data Source selection
- SAP BW queries
- HANA live views
- SAC models
When creating a new data analyzer, you will select (3)
- system type (bw,hana,etc)
- Connection (eg, s4hana)
- Data source (model)
Components of Data Analyzer interface
- bullet proof user interface
- for quick, adhoc queries
- drag&drop, pause refresh, swap axis filtering
- save results as “insight” file
Data analyzer - what is available
- table
- filters
- builder panel for dims/measures in the table
- menu bar has pause refresh
- edit prompts
- table formulas
Data analyzer - what is not available
- calculated measures
How to connect to visualize data in Data Warehouse Cloud (DWC) from an SAC story
- live connections only
- DWC contains an embedded SAC, to directly access data as a live connection
- do not need to create an SAC model to access DWC as a datasource
- need to set SAC as a trusted origin in DWC
Integration with BW or BW4/HANA can be done in 2 ways
- live connection
- import connection
Advantages of live connection to BW or BW4/HANA (4)
- access bw features that cannot be accessed through SQL or MDX query interfaces
- leverage BW mettdata without additional modeling
- reuse authorization concepts
- connects to BW and generate hana views
Advantages of import connection to BW or BW4/HANA (3)
- use existing BW queries to import data into the cloud
- applies SAC native security concepts (eg if sec is in SAC)
- leverages calc engine of HANA for additional analytics use cases
Prereqs of import connection to BW or BW4/HANA (3)
- BW systems is version 7.3x +, BW4/HANA or SP4+
- BTP Connectivity Cloud Connection installed
- SAP Analytics Cloud agent installed
BW elements supports in SAC stories (5)
- time dependent hierarchies
- bw variants for prompts
- personalization of prompts
- bw structures
- parallel execution of BW queries
- merge prompts
- Variable support
What type of BW variable support is offered in SAC Stories
- exit/auth variables that are input-ready
- operators - define range exclusions of Dim members
- value help/drop down ability will show booked values
What type of BW structures are supported in SAC Stories
- can use bw queries with two structures
- calculated cell values created in Cell editor will work
Explain parallel processing of BW queries in SAC
- admin can set number of parallel sessions allowed
- stories w/ multiple queries will execute in parallel
- only use when performance improvement is required
