In my previous blog I described how we can consume HANA Views using UDT(.unv) in web intelligence.
Here we will see how we can consume HANA views(variables and input parameters) in webi through IDT(.unx).
Keep in mind only JDBC middleware is supported for consuming variables and input parameters
At first make sure you have View created in HANA Studio and variables or input parameter over it.
Once this is executed we can create a Variable over this analytical view
This was the HANA part and after this View is executed in HANA Studio and ready to consume in BO we can now move to Information Design Tool and see how we can create connection over this HANA view and use variables and Input Parameters
So now we are creating a relational connection using JDBC as middleware for HANA
You need to specify HANA server name,port number and redentials remember in order to consume variables/input parameters only JDBC is supported with webi and not ODBC.
Once local connection is created we will now reate HANA Business Layer as below
This will allow you to create data foundation and business layer in one go,once you have given names below will be the pane to select HANA View
Once you click on OK here it will create both data foundation and business layer.In the data foudation once we click on table we can see the variable dependant on it.
The next steps is very crucial we have created data foundation and business layer over a local connection hence inorder to publish the HANA business layer we need to first publish the connection and then point the data foundation to the published connection shortcut(.cns)
Now the HANA Business Layer is ready to be published to repository and for reporting.
Now you can create webi over this HANA universe and run it successfully.
Hope this blogs helps all 🙂
I am open for any comments or queries on this.