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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply