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.