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.