In my last blog I wrote about how to get content from the web, load it into HXE and do some text analysis on it:
Today I would like to show you how to create a calculation view on top of my loaded StackOverflow data (table), connect it to Lumira and create a story.
You need some additional rights
In order to make use of a calculation view, you will have to grant select rights to your schema holding your data. In my case (as I am lazy 😉 ) I use the SYSTEM schema which is part of my SYSTEM user. Open a SQL console and fire away:
GRANT SELECT ON SCHEMA SYSTEM TO _SYS_REPO WITH GRANT OPTION
That’s all you need to do.
Next, do the regular modelling you would always do in Eclipse: create a package and a calculation view.
Do a Data preview if you want to check your result:
We have data!
Connecting to Lumira
As of Lumira 1.30 you can connect to HANA with a local connection over HTTP or HTTPs. In order to do so, you need the host name (hxehost if you mapped the IP address of HANA to the Host file in Windows) and look up the port via the adminstration console in Eclipse.
Normally you would need the SQL port of the indexserver, but because we are using a HANA Multitenant Database Container (MDC) system and are logging into the SystemDB, there is no indexserver running. In fact you need the nameserver. You can read up on MDC and server components here:
Port 30013 is what we need.
Open up Lumira and make your connection:
Et voila, you’re running a BI data mart in HXE!
Create your story and your off to your very first cool dashboard on your own HANA kit:
So what about Design Studio?
I have been trying to use the Ina connection, but came to the conclusion that it simply does not work in the SystemDB, I believe it only works in Tenants which we do not have. No fear however, ODBC still works like a charm.
Install the HANA Client tools (software download section on service.sap.com) and configure an ODBC connection in c:\windows\system32\odbcad32.exe:
Your connection will automatically show up in Design Studio and you’re all set:
Go UI5 rockstars, keep answering those questions!