SAP Analytics Cloud integration with SAP BW Technical Webcast Recap
This webcast covered SAP Analytics Cloud Integration with BW; technical, end to end
Technical overview, backend prerequisites.
If you are interested in related webcast, join us tomorrow:
The legal disclaimer applies; anything in the future is subject to change.
Figure 3: Source: SAP
2 ways to connect
Live connection – baseline of 7.5/4 with SP’s and you must apply SAP Notes on top
See SAP Note 2541557
How start applying notes?
Notes are specific to SAP Analytics Cloud
Figure 4: Source: SAP
Data import connnectivity is covered above
Figure 5: Source: SAP
2 modes of connectivity
Live connectivity – approach most customers want; connect directly, leverage rich metadata and no modeling, no data replication
Leverage underlying data authorizations
Data import is not a dark horse; if using data from different sources
Figure 6: Source: SAP
Getting connectivity to work
If using reverse proxy approach, no need to change
If starting new deployment, SAP recommends CORS
Figure 7: Source: SAP
CORS technical specifics
Figure 8: Source: SAP
3 components to install
Figure 9: Source: SAP
Install HANA Cloud Connector – manage transfer of on-premise to SAP Analytics Cloud
Uses TLS encryption; same as what banks use
Set up agent; used to help manage connection and query request to on-premise
SAP JCo connectors – connect to BW system
In next wave or 2, new component that bundles HANA Cloud Connector, Jco and agent together
Could be an alternative for those who want a simplfied connectivity experience
BW Query Concepts
Figure 10: Source: SAP
Talking to BW queries
Live connection and data import
Leveraging your existing investment
Data import – about leverage selective BW query concepts; extract query results into SAP Analytics Cloud
Once acquired in SAP Analytics Cloud not tied to BW OLAP engine
Figure 11: Source: SAP
Different BW metadata concepts
Live connection almost fully satisfy – not support TIMS – part of the roadmap; early next year
Data import nuances; acquire the data, map dimensions as part of the model
Figure 12: Source: SAP
Display attributes, structures; recommend Live connectivity
Figure 13: Source: SAP
Live connectivity is recommended here
Recently delivered support for BW Variants and personalization
Figure 14: Source: SAP
Core concepts make the live connectivity “special”
Figure 15: Source: SAP
Display settings – scaling, etc. part of the live connectivity workflow
Figure 16: Source: SAP
Safety belt protects against large dataset retrieval
Figure 17: Source: SAP
Query read mode; setting in BW that decides how OLAP processor navigates in client; use transaction RSRT
Figure 18: Source: SAP
BW query design considerations; not redesign queries, try to leverage existing queries with SAP Analytics Cloud
Figure 19: Source: SAP
Administrative feature introduced in SAP Analytics Cloud; if have story page with 6 different charts/widgets and pointing to different queries those would be executed in parallel
Figure 20: Source: SAP
Storybuilding feature; similar to pause/refresh in Analysis Office
Design time feature
Figure 21: Source: SAP
Some of the changes in Q3/Q4 delivery planning
DATS support improving
Product direction – planned for 2019
Figure 22: Source: SAP
Q3 – additional chart types
Waterfall charts may come in Q4
Figure 23: Source: SAP
Chart to chart filtering is being enhanced (called Linked Analysis)
– when charts are based on different BW queries
– planned for end of Q3
Figure 24: Source: SAP
Search to insight was introduced last month
Planned for Q4 – live BW models
Figure 25: Source: SAP
Data blending – many customers are asking for this
Looking at Q3 delivery
Questions & Answers
Q: Will BW based RRI work with SAP Analytics Cloud?
A: Not yet; aware of this; working on as part of the product backlog
Q: Are there customers live with a live BW connection?
Q: End users want to create ad-hoc BW queries; Eclipse based BW query desiger has too much overhead; will SAP Analytics Cloud have it’s own version?
A: No, you can use traditional BEx query designer or the BW modeling tool
Q: As the safety belt assists limiting data, is there a possibility to limit it for SAP Analytics Cloud?
A: No, the safety belt is managed from IT
Q: What is the row limit for BW live connections?
A: Think of BW live connection with a safety belt – could be restricted
Within SAP Analytics Cloud – different visualizations have different limits and data points
Not specific to live connections
Q: Currently using data import; can we switch model to live connection?
A: No, can’t switch
Q: Will SAP Analytics Cloud cover the same functionalities as Analysis for OLAP?
A: Over time, will bring use cases to SAP Analytics Cloud
ASUG SAP TechEd Preconference Sessions are open for Registration!
Jumpstart your conference experience by attending an ASUG pre-conference seminar. Join the best minds in the industry, in a unique configuration to foster face-to-face networking and knowledge sharing.
Data Visualization and Dashboards with SAP Analytics Cloud and App Design with SAP Analytics Cloud
Hands-On | Full Day, 8:00 a.m.–5:00 p.m.
Fee: $745 ASUG Member | $845 ASUG Nonmember
Date: October 1
This full day, hands-on workshop provides an overview of SAP Analytics Cloud and of its app-building capabilities. Attendees will learn what role SAP Analytics Cloud and its app-building capabilities can play as part of the overall SAP landscape and how these can integrate with existing on-premise and cloud-based data sources. You will have the opportunity to work directly with SAP Analytics Cloud and app-building features, in combination with SAP Business Warehouse and SAP HANA, to create a variety of dashboards.