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.

7 Comments

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

    1. Frank Schuler Post author

      Hello Bing,

      No, you do not have to import a project from GitHub to install SHINE for SAP HANA XS Advanced Model from the respective XSA Software Component Archive (SCA). Both options are mutually exclusive and in my blog I describe the SCA option.

      Best regards

      Frank

      (0) 
  1. Fernando Faian

    Hi Frank,

    Thanks for your post. I successfully installed it. I had trouble with the schema name just like yourself. I also had the timeout issue. For the timeout, i also had to perform the deletion of both CROSS_SCHEMA_SYS and CROSS_SCHEMA_SYS_BI services before trying again. I followed the guide SAP_HANA_Interactive_Education_SHINE_for_SAP_HANA_XS_Advanced_en.pdf“. I also Reinstalled the Software Component with the option ” –o ALLOW_SC_SAME_VERSION”.

    Thanks,

    Fernando

     

    (0) 

Leave a Reply