Skip to Content
Author's profile photo Frank Schuler

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

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.

Assigned tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Bartosz Jarkowski
      Bartosz Jarkowski

      Excellent blog Frank, as always!

       

      Best regards

      Bartosz

       

      Author's profile photo Witalij Rudnicki
      Witalij Rudnicki

      Hi Frank. As mentioned in http://www.sap.com/developer/tutorials/hxe-ua-getting-started-binary.html the SHINE is not pre-installed on HXE 2.0 and its installation is an optional step. Thank you for sharing steps in more details! Regards.

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog Post Author

      Thank you Witalij,

      You are right. I had missed that tutorial and adjusted my blog now accordingly.

      Best regards

      Frank

      Author's profile photo Bing Liu
      Bing Liu

      Hi Frank.

      I am trying to install SHINE in HANA Express 2.0 with references including this blog and SAP_HANA_Interactive_Education_SHINE_for_SAP_HANA_XS_Advanced_en.pdf v1`.4.
      There are many differences makes me confused. Could you clarify a question for me? I will appreciate.

      if I choose to use  SHINE for XSA Software Component Archive (SCA) to install, do I need import a Project from GitHub to SAP WebIDE ?

       

      Regards.

      Author's profile photo Frank Schuler
      Frank Schuler
      Blog 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

      Author's profile photo Bing Liu
      Bing Liu

      Hello Frank.

      Thanks for your prompt answer.

      Very helpful.

       

      Author's profile photo Fernando Faian
      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

       

      Author's profile photo HP Seitz
      HP Seitz

      Hi Frank,

      as always valuable content from your side, thx.

      As now many of the steps you described in your post are part of the SHINE installation script (as of HANA Express Edition SPS02), I posted an update on this topic. It can be found here:

      Install SHINE for XSA on SAP HANA 2.0 Express Edition SPS02

      Best Regards, HP