Enable Smart Business to Discover HANA Analytic OData Services by HANA views
In my previous blog, I used OData Service Discovery to Measure my Raspberry Pi sensor data on the go with the Smart Business Service.
However, inspired by Raja Prasad Gupta’s blog Connect On-Premise HANA to Smart Business Service – An End-to-End Example I want to Enable Smart Business to Discover SAP HANA Analytic OData Services by SAP HANA views.
To start with, I download the respective Delivery Unit HANA CONT. SBS DISCOVERY 1.0:
And deploy it to my SAP Cloud Platform instance. To be able to do this I need Role sap.hana.xs.lm.roles::Administrator:
To simplify the OData discovery, I make the package anonymously accessible. To start with, I create a role with access to the 2 Views and the general analytic privilege _SYS_BI_CP_ALL:
role sap.smbaas.core.odata.modeler::anonymous { catalog sql object "_SYS_BIC"."sap.smbaas.core.v/GET_HANA_VIEWS": //Objecttype: VIEW SELECT; catalog sql object "_SYS_BIC"."sap.smbaas.core.v/GET_ODATA_FOR_HANA_VIEW": //Objecttype: VIEW SELECT; catalog analytic privilege : "_SYS_BI_CP_ALL"; }
Based on this I create my anonymous.xssqlcc file:
{ "description" : "anonymous", "role_for_auto_user" : "sap.smbaas.core.odata.modeler::anonymous" }
Modify my .xsaccess file:
{ "exposed" : true, "cache_control": "no-cache, no-store", "authentication": null, "anonymous_connection": "sap.smbaas.core.odata.modeler::anonymous" }
And add a .xsjs file:
var conn = $.db.getConnection("sap.smbaas.core.odata.modeler::anonymous");
So, that I can Activate anonymous access:
For my Business System, I can now choose Service Discovery Type HANA Calc View-based Discovery:
Subsequently, in my Create KPI or OPI app I can Select view:
While OData Service Discovery works perfectly fine, I like the for me more intuitive way to Discover SAP HANA Analytic OData Services by SAP HANA views.
New NetWeaver Information at SAP.com
Very Helpfull