Technical Articles
How to setup Smart Insights on Live HANA
In this blog here, I shared 3 reasons of WHY Smart Insights feature in SAP Analytics Cloud is important for you and your day to day analysis.
Now as we have Live HANA data support starting with Wave 20 for fast track and Q4 QRC 2020 release here are the details of how to get the end to end setup established.
Overall Setup
Architecture
Architecture Diagram for Smart Insights on Live Data
Metadata Generation for Smart Insights –
Smart Insights algorithm that highlights Top 5 Contributors for your input data is based on 2 set of calculations. One that requires metadata information such as Number of Dimensions, Number of Members, Levels of Hierarchical Dimension and then other that computes the rank on the UI or story considering user context/filters/authorizations. Now the first one happens on backend because:
- Depending upon data volumes, the metadata query could be time consuming and doing it on front end may hamper user experience.
- Metadata contains statistical information about structure of underlying HANA view and hence it does not change frequently. For a SAP Analytics Cloud model, typically it would be only one time activity or only when there are huge structural changes (e.g. new tables/joins in HANA view). So the results of metadata query can be persisted on cloud cache in order to make use of it later on when Smart Insights is triggered in UI.
Use of Cloud Connector for on-premise data connectivity –
Cloud Connector acts as a secure tunnel between your company’s private firewall and public domain of SAP Analytics Cloud. In order to obtain metadata information from on-premise HANA views, SAP Cloud Connector is considered to be most secured and effective reverse proxy.
A new Technical User –
A HANA user with permissions to read metadata information is needed, which a business SSO user configured in SAP Analytics Cloud may not have. The minimum privileges required in HANA for this user are:
- InA role – sap.bc.ina.service.v2.userRole::INA_USER
- The SELECT privilege on the _SYS_BIC schema.
- The SELECT privilege on all dependent objects, such as tables or other dependent modeling
views.
Detailed Steps in SAP Analytics Cloud
Having the above setup done for Technical User in HANA and SAP Cloud Connector pointing to HANA DB, this is what as Administrator user, you will need next to tie everything together in SAP Analytics Cloud:
- Via System->Admin->Datasource Configurations, make sure the Live Data Sources flag is switched ON. Kindly note for Smart Insights, only metadata and not the actual data leaves the network.
- For existing Live HANA connection or when you create a new one, Enable model metadata generation for Smart Insights and provide Cloud Connector and Technical user-password in Advanced Features.
- Now use the ‘Generate model Metadata for Smart Insights’ function from the Connections UI and trigger metadata generation by simply clicking ‘Generate Metadata’ button from the popup. (note metadata generation is automatically triggered for any new models that gets created against live HANA connection for which above setup is done). In case of issues, refer to SAP Note here.
- Test Smart Insights from Story/DiBo having models with live HANA connection setup or ask business users to confirm.
Enjoy! And Share any feedback or questions in the comments.
Thanks for putting this document together Priti! We started making use of Smart Insights in our landscape right after reading your blog.
Thanks Gurbir Brar Glad to hear this. Let us know how it goes and if you need any further help for making use of it.
Hello Priti,
I followed your instructions to set up the customizing, but when I tried to run "Generate model Metadata for Smart Insights", I get the information under status: Metadata is available for: 0 of 2 models. Cannot generate model metadata.
Do you have any idea, why I can't generate the metadata?
Kind regards,
Thomas
Hello Thomas Quäbicker , Can you kindly mention what error messages do you seen in Troubleshooting section in Metadata Generation popup. Most common reasons for not having any models with metadata generation is connection or authorization issue. If you can access Calc Views in HANA and read the data with technical user that you used in configuration then that will be the first success check. There might be other reasons if the above one does not apply here and see the detailed troubleshooting note here.
If you still face issue, please feel free to raise support ticket so we can investigate for specific case.
Thanks Priti for such detailed information. We have SAC connected to HANA DBs using proxy, could you please help us with some details if we need cloud connectors to enable smart insights. If yes then how. Thanks in Advance !
Hi Vatan Choudhary
See the official documentation and pre-requisites here.
Smart Insights documentation will be under 'Augmented Analytics' -> Smart Insights in main SAC help pages. And then you should be able to navigate to Live HANA setup from main Smart Insights page.
To your question - Yes SAP Cloud Connector is needed for HANA connection types we support currently (Direct). SAP HANA cloud is not supported at the minute and Tunnel type is also on roadmap.
Hopefully that helps. And then if you get specific issue or question further, let us know.
Hi Priti Mulchandani sorry to bother but please could you point me to the roadmap item where Tunnel connections will be supported for Smart Insights to HANA? Regards, H
Hi Henry Banks , there are no immediate roadmap items for support for Tunnel connection but referring to Robert McGrath to confirm on this.
Hi Henry Banks
Priti is correct, currently we do not have planned dates for this.
Rob.
Hi Priti Mulchandani many thanks for this blog.
Quick question from my side if i may, does Smart Insights require HANA APL at source? or is that only for Smart Predict scenario builder?
Regards, Henry
Hi Henry Banks - No Smart Insights does not need APL or any additional component to be present in HANA. On the other hand Smart Predict does have dependency on APL.
Hi Priti Mulchandani many thanks for this blog.
My question:
Is it possible with the approach you descibed to use Smart Insights on a BW/4HANA application. I.E. to create HANA views for BW queries and then to use the HANA views as data source for Smart Insights?
Best regards,
Matthias
Hi Priti Mulchandani , I am trying to use smart features for live connection. Have enabled the Live Data Sources flag in the Datasource configuration. However I am not able to find the advance feature option while trying to edit the connection. Please advise. Thanks
Hi Swapnil Gujar what kind of Connection type is it? and what's the data source ?
(for example: Live -> HANA + Connection type: Direct ... will show "advanced options" at the bottom of the connection dialog)
regards, H
Hey Henry Banks It is a live data connection with SAP HANA cloud as a data source ? If you could share screenshot of "advance options" that would be nice.
Hi Swapnil Gujar unfortunately there are some restrictions with that combination. i was looking into the help documentations here:
https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/6ac0d03d53f3454f83d41c6f51c2fc31.html
and there's an excerpt that states: << Smart Insights is supported on acquired and live SAP HANA direct connections only. >>
alas, when i chose the 'hana cloud' connection type - advanced options disappears.
regards, H