Add SHINE for SAP HANA XS Advanced Model to your HANA 2.0, express edition

[architectSAP]

After installing the HANA 2.0, express edition, I assumed that the SAP HANA Interactive Education (SHINE) for SAP HANA 2.0 SPS00 for SAP HANA XS Advanced Model would have been pre-installed, because of the existence of a XSA_SHINE user, but the XSA app shine-web, does not seem to exist in Space SAP:

xs app shine-web -urls

Checking this developer tutorial makes it clear that the SHINE installation is optional and therefore I am adding it as per the respective guide.

To start with, I check the prerequisites. XSA app jobscheduler-broker exists, but has not been started:

xs app jobscheduler-broker

Therefore, I start it:

xs start jobscheduler-broker

Next I check XSA apps xsa-admin and webide and they both exist and are running:

xs app xsa-admin -urls

xs app webide -urls

So I check the XSA_SHINE user, and that seems to have been setup correctly already:



As well as the Space setup:



Therefore, I grant my XSA_SHINE user the required privileges for the installation of the SHINE for XSA software component archive:

Grant SELECT on "SYS"."M_TABLES" to XSA_SHINE;

Grant SELECT on "SYS"."TABLES" to XSA_SHINE;

Grant SELECT on "SYS"."VIEWS" to XSA_SHINE;

Grant SELECT on "SYS"."USERS" to XSA_SHINE;

Grant SELECT on "_SYS_BI"."M_TIME_DIMENSION" to XSA_SHINE WITH GRANT OPTION;

Grant EXECUTE on "SYS"."SERIES_GENERATE_TIMESTAMP" to XSA_SHINE;

And I continue to select my system to Generate Time Data:



With the recommended settings:



Finally, I adjust the sap-xsac-shine-1.2.2-XSACSHINE02_2.mtaext file and ensure to use the correct SQL/MDX access port for standard access to the system database, especially in a multitenant system like the HANA 2.0, Express Edition:



Especially important is also NOT to use the user name as the schema name, as one would potentially tend to do, but something different, otherwise the installation will fail:



And Deploy the SHINE for XSA application as user XSA_SHINE:



Which registers successfully:



Now XSA app shine-web, exists in Space SAP:



And I can login with the listed URL:



To first check, whether my system meets the prerequisites, which it does not, because it is missing the SHINE_ADMIN role collection:



However, this is easily resolved by choosing Create Role Collections:



And assigned to my XSA_SHINE user:



So that I can now use the Data Generator. Since I would also like to check the performance of my HANA system, I am going for BIG data (1,000,000 Purchase Orders and 1,000,000 Sales Orders):



Which gives it an about 10 minute spike:



But subsequently all apps run absolutely smoothly:



Like for example the Sales Dashboard:



From here a good next step might be the openSAP SHINE Reference for Native SAP HANA Application Development course.