In my previous blog posts I showed you how to install and configure SAP Crystal Reports, version for SAP HANA and SAP Lumira Server.

How to install SAP Lumira Server, Publish Datasets and Stories

Update SAP Lumira Server 1.17 & New Features

The specified item was not found.

In this blog I will show you how you can configure your system so you are able to publish SAP Crystal Reports documents that are stored on SAP HANA to the SAP Lumira Server launchpad. More information can be found in chapter 9 of the following document: http://help.sap.com/businessobject/product_guides/CRforHan10/en/cr_han1_install_en.pdf

To enable Crystal Reports content to be listed and viewed from the Lumira Server launchpad, there are specific configuration steps that must be taken in order for the integration to work.


The following is the basic workflow to enable reports to be listed or viewed in the launchpad:

  1. Report authors save reports to the SAP HANA system.
  2. Promote reports in HANA. To promote a report, the report designer or another administrator needs to run a script in the web browser. The user settings need to be configured in the Hana SQL Connection Configuration (SQLCC).
  3. After the reports are promoted, users browse to the Lumira Server Launchpad to see the list and view the reports.


Accounts can be created and assigned to roles in SAP HANA Studio. In addition, users must be granted sufficient permissions to select data in analytic and calculation views that they need to access in SAP Lumira Server.


Let’s start with creating new user (LUMIRA_CR_PROMOTION) in the SAP HANA Studio so we can configure the SQLCC to promote CR content.


CRL_01.png


Make sure you grant the following role to this user:


  • sap.bi.common::BI_TECH_USER


Deploy the user.


CRL_02.png


If you create a user via the GUI we have to reset the password as it is flagged as initial. To do this you can for instance browse to the Lumira Server launchpad: http://<hana host name>:<XS engine port>/sap/bi/launchpad


CRL_03.png


Log in and you will be prompted to change you password.


CRL_04.png


Click on ‘Change Password’.


After you have successfully logged on please log off.


CRL_05.png


Next step is to ensure an administrative user (preferably not SYSTEM) has the following roles granted:


  • sap.hana.xs.admin.roles::RuntimeConfAdministrator
  • sap.hana.xs.sqlcc::Administrator


Browse to the following URL and login with this administrative user: http://<hana server name>:<XS engine port>/sap/hana/xs/sqlcc/


Click on the ‘sap.bi.activationplugin.logic.lib::ActivationRepoConnection’ Folder and fill in the user you have created. In our example ‘LUMIRA_CR_PROMOTION’.


CRL_06.png


Click on ‘Save’.


To enable users to view Crystal Reports content grant them the sap.bi.common::BI_DATA_CONSUMER role.


Alternatively the sap.bi.cr.roles::CrystalReportConsumer role can be granted the sap.bi.common::BI_DATA_CONSUMER role. This will automatically give all users that have been granted the sap.bi.cr.roles::CrystalReportConsumer role access to Lumira Server launchpad.


Final step is running a promotion script to display the latest version of reports in the Lumira Server launchpad. The promotion script must be run whenever a report is updated and saved to SAP HANA; the report should be made available to launchpad users.


To run the promotion script, use the following URL: http://<hana server name>:<XS engine port>/sap/bi/activationplugin/activate


Log in with a user that has the sap.bi.common::BI_DATA_CONSUMER role granted.


  • If there is an activated report not yet promoted in Lumira, then the script automatically executes and returns the following message: Activation Successful

CRL_07.png

  • If there are no activated reports or all activated reports have already been promoted, the script returns the following message: No objects to activate.

CRL_08.png

Now let’s login to the SAP Lumira Server launchpad and try to find the SAP Crystal Report I created previously on SAP HANA.

CRL_09.png

Click on the report and it will open with the SAP Lumira Server launchpad!

CRL_10.png

If you have any questions please don’t hesitate to contact me!

Thanks for reading!

With kind regards,

Martijn van Foeken

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply