SAP Analytics Cloud Integration with SAP HANA Webcast Recap with Q&A
Legal disclaimer applies; things in the future are subject to change
Self-service data discovery, mobile consumption on the go; broaden reach of SAP Analytics
Hybrid strategy to leverage things like SAP HANA
Leverage your HANA investment; get the maximum benefit of data and data security
Content is free, help jumpstart your projects
Comes as part of SAP Analytics Cloud subscription
Live – direct consumption of views without modeling
Keep data secure behind a firewall
You do not need to replicate data
Reuse authorization concept
Data import – extending use case beyond what live connect can, such as predictive, planning
Browser – where everything is brought together and rendered
Recommend using direct live connection
Guided play list is available
By end of year, will deprecate reverse proxy for new tenants going forward
Recommend CORS going forward for live connectivity
Using public wifi, reverse proxy + CORS (reverse proxy in DMZ to safely publish on premise to internet)
Generic OData connector
Last month released a simplified deployment kit – simple installer, has component – TomCat, Connector + Cloud Agent – one simple app to download
Recommends SAP HANA 2.0
Data import requirements are looser
App Design, planned GA end of this year
Targeted towards power user, professional designers
Integrated with SAP Analytics Cloud
Data Connections, visualizations, they are fully available as part of experience
Version 1 release will have widgets, such as dropdown, customize through scripting
App Design is being built by Lumira Design team
What is an app and why do I need one?
Applications are intended to be created by a few experts and consumed by many
Build standard content through reusable components
Appeals to design professionals
Story versus app
Outside of BI, available now as part of SAP HANA Live Connections
Search to insight – “smart assist features” – the beginning of integration of machine learning capabilities
Works for English only
Audible questions planned next year
Blended join at the visualization layer, primary with secondary, common linked dimensions
Available in guided playlist
How blending happens – HANA with Excel
Custom sort – requires HANA 2.0
Show all countries with revenue over $10M – logically at each level – story to page to widget
Concatenate, grouping together
Granularity with time
Evaluate best practices with HANA calc view design
Visualize aggregated data where possible; detailed information goes to another page (use hyperlink) – reduce clutter
Design time feature
November 13 Smart Predict
December 4 INFL: Mobile BI Influence Council Re-launch
With CORS how do users outside the organization access SAC that do not have VPN accounts?
The recommendation is to place SAP Web Dispatcher in the DMZ and do a simple redirect. There is more information under Step 10 of the Guided Playlist at https://www.sapanalytics.cloud/guided_playlists/sap-hana/
Why it is only possible to write back data from SAC only through BPC? Customers who do not want to use BPC as a planning and consolidation tool still need to purchase licenses for BPC. Is it the best solution?
If you only have SAP Analytics Cloud then you can update and collaborate on your plans in SAP Analytics Cloud. What write base destination are you thinking of?
in case of Data Import – do we have limitation of data size
yes there is a limitation per import run and you can do successive runs to append additional data. More details at https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be1f01.html#loio11b4e5ff76eb4747bc255d7037be1f01__p_connectimport and https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/6aa6a99d4eb5467896c4fd47bc9c7642.html
CORS cannot be used for data import?
CORS is only used for Live connections.
Web dispatcher can be used to route requests to a DIRECT live connection and the configuration is much simpler than previously done with the PATH connection type.
Hello, we have a customer who’s asking for a PoC, consuming a table from the S/4 HANA. Do you have like a guide for this?
S/4HANA connections are documented in Guided Playlist and Documentation: https://www.sapanalytics.cloud/guided_playlists/connect-sap-s4hana/ and https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/d2a1edf7cda74315a2c5052de8a3a4eb.html
It is possible to connect SAP Analytics Cloud with an SAP ERP Suite On HANA located in Amazon Cloud y not exposed to internet
yes you would use the SAP Cloud Connector. We have generic documents for this and if you Google you will find some specific ones from Amazon. Our generic ones are https://www.sapanalytics.cloud/guided_playlists/connect-sap-erp/ and https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/f1f537fecf6e425bbd21b36bdd2a3fe3.html
Can we connect SAC Analytics cloud using live/direct import connection to a HANA db on neo cloud platform
you can do a Live connection to HANA 1.0 on SAP Cloud Platform per https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/f733b47974674d2da65cef3db90ec088.html and https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/a30b5127419a4fd0aeef7be91fdf9836.html
Hi, we have installed the Agent Client onpremise to connect the cloud. Can you tell me please, which ports and urls we need to authorize in our firewall ? Our base url is us3.hana.ondemand.com. Thanks.
the SAP Cloud Connector connects using the standard 443 port. More information is at: https://help.sap.com/viewer/cca91383641e40ffbe03bdc78f00f681/Cloud/en-US/e6c7616abb5710148cfcf3e75d96d596.html
What limitation will be there in terms of data load for data import option
Is there an Excel connectivity with the planning capability of SAC?
SAP Analytics Cloud can import from excel either directly from a file or via a file server: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/6d2b5ba745a548d099602aaed21b8466.html
Can you still import excel files while having a sap cloud as datassource?
you can import directly from the file or from a file server: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/6d2b5ba745a548d099602aaed21b8466.html
Can we use SAC for analytical needs of OLTP data in SAP ECC system ?
you can import the data into SAP Analytics Cloud per: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/f1f537fecf6e425bbd21b36bdd2a3fe3.html
with the iOS app. What kind of certificate the customer should use? is the wildcard domain certificate useful?
for Linked Dimension between live connection Models what is the suggerst, because In my implementation is running sLowly more than 5 minutes for showing results
there are some performance recommendations here: https://www.sapanalytics.cloud/resources-bi-performance-best-practices/
Pros and Cos for live connectivity and data import functionality?
there is some information on this here: https://www.sapanalytics.cloud/resources-sap-analytics-cloud-content-live-vs-import/
Can SAC create a waterfall type report
yes this is a supported chart type: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/51709b725c954a969de52355fbd9a73e.html
How to maintain master data for existing models