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.
Excellent blog Frank, as always!
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.
Thank you Witalij,
You are right. I had missed that tutorial and adjusted my blog now accordingly.
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 ?
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.
Thanks for your prompt answer.
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".
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