Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
architectSAP
Active Contributor
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 rajaprasad.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.
1 Comment
Labels in this area