Skip to Content

Creating a category tile for SAP Lumira stories

Note: This content is only for SAP HANA administrators.

You can group SAP Lumira stories into categories using SAP Fiori tiles. This can make it easier to find related stories - for example, you can create a category for all stories with the string "Human Resources" in their title. End users can do this in SAP Fiori by following the instructions in the SAP Lumira Server user guide at help.sap.com/lumira or SCN blog SAP Lumira Server: SAP Fiori launchpad integration , or an administrator can do it in SAP HANA studio. Both methods offer the same functionality, but the SAP HANA Studio method creates stories that are part of a catalog and can be used by everyone who had access to the catalog. Also, with the SAP HANA Studio method, categories can be created ahead of deployment time.

This document explains how to create a new category tile in SAP HANA Studio.

Prerequisites

  1. Ensure your SAP HANA studio is connected to SAP your SAP HANA system.

Set up the repository in HANA Studio

1. Open Hana Studio and switch to the SAP HANA Development perspective.

2. Switch to "Repositories" view.

  • To add this view, select Window > Show View and choose SAP HANA > Repositories.

3. Right-click on the repository pane and choose Create Repository Workspace.

4. Select your SAP HANA System, then specify the Workspace Name and the Workspace Root.

5. Select Finish to create the new repository.

Set up a new Project

1. Switch to Project Explorer view.

  • To add this view, select Window > Show View > Project Explorer.

2. Right-click on the Project Explorer pane and choose New > Project...

3. In the project wizard, select General > Project and select Next.

4. Specify your project name, for example LumiraStoryGroup, and select Finish.

Associate the project with the repository

1. In the Project Explorer pane, right-click on the project you created in the previous step.

2. Select Team > Share Project...

3. Choose the Repository Workspace you created in the previous step.

3. Select Finish.

Create an Application Site

1. Right-click on your project and select  choose New"> Other...

2. From the create wizard, select SAP HANA > Application Development" > UIS Application Site and select Next.

  • Ensure the Parent Folder is the project you created in  the previous step. You may have to select it.

4. Specify the File name, Title and Description.

5. Select the Fiori LaunchPad as the Site type and select Finish.

6. Select Save to save the project.

7. Right-click on the project and select "Team" > "Activate".

  • You must activate the project to make it available to the SAP HANA system.

Create a Catalog

1. In the Project pane, right-click on your project and select New > Other...

2. From the creation wizard, select SAP HANA > Application Development > UIS Catalog and select Next

  • Ensure the Parent Folder is the project you created in  the previous step. You may have to select it.

4. Specify the File name and Catalog Name then select Finish.

5. Expand the project.

6. Double-click on the LumiraStoryGroup.xswidget to open the SAP Fiori catalog designer.

Create Dynamic Content Tile

Create a tile to appear in SAP Fiori.

1. On the SAP HANA Catalog Editor, click + to add a Tile.

2. Select  Dynamic App Launcher tile on the designer, then click on it again to enable editing.

3. Enter the following:

FieldDescription
TitleThe tile's title. This will be visible to customers.
SubtitleOptional. The tile's subtitle. This will be visible to customers.
iconEnter sap-icon://bbyd-dashboard
Number UnitEnter Stories
Service URL for a single string

Use this format to search for a single string (even if the string contains a space). To search for multiple strings, see Service URL for multiple strings.

Enter /sap/bi/launchpad/v3.xsodata;o=LUMIRA/Items/$count?$filter=ItemType+eq+%27sap.lumira.story.type%27%20and%20substringof(tolower(%27<SEARCH_STRING>%27),tolower(Name))

Where <SEARCH_STRING> is the string that the story titles in this category will contain.  For example, Sales%20Report will create a category that contains all stories with the string Sales Report in the title.

<SEARCH_STRING> must be correctly URL-encoded. For example, replace spaces with  %20.

Note that <SEARCH_STRING>  is enclosed with URL-encoded quotes. That is, surround the string with %27.

Example: Category will contain all stories with "Sales Report" in the title

/sap/bi/launchpad/v3.xsodata;o=LUMIRA/Items/$count?$filter=ItemType+eq+%27sap.lumira.story.type%27%20and%20substringof(tolower(%27Sales%20Report%27),tolower(Name))

Service URL for multiple strings

You can search for multiple strings.  For example, search for all reports that contain 'Sales Report' AND '2014'. At this time, OR is not supported.

Enter /sap/bi/launchpad/v3.xsodata;o=LUMIRA/Items/$count?$filter=ItemType+eq+%27sap.lumira.story.type%27%20and%20substringof(tolower(%27<SEARCH_STRING_1>%27),tolower(Name))%20and%20substringof(tolower(%27<SEARCH_STRING_2>%27),tolower(Name))

Where <SEARCH_STRING_1> and <SEARCH_STRING_2> have the same format as <SEARCH_STRING_1> in Service URL for single strings.

Example: Category will contain all stories that have  Sales Report AND 2014 in the title

/sap/bi/launchpad/v3.xsodata;o=LUMIRA/Items/$count?$filter=ItemType+eq+%27sap.lumira.story.type%27%20and%20substringof(tolower(%27sales%20Report%27),tolower(Name))%20and%20substringof(tolower(%272014%27),tolower(Name))

Refresh Interval in SecondsUse the default.
Use semantic object navigationEnsure this is checked.
Semantic ObjectEnter LumiraAnalytics
ActionEnter listBIContent
Parameters (for single strings)

Enter itemType=sap.lumira.story.type&keyword=<SEARCH_STRING>


Notice that you do not enclose the search string in quotes

Example: to search for stories that contain Sales Report in the title:


itemType=sap.lumira.story.type&keyword=Sales%20Report

Parameters (for multiple strings)

To search for multiple strings, enter the search terms separated by  URL-encoded comma, %20


Example: to search for stories that contain  Sales Report AND 2014 in the title

itemType=sap.lumira.story.type&keyword=Sales%20Report%2C2014

4. Select Save.

5. Select File->save to save the xswidget file.

6. Right click on the project and select Team > Activate.

Enable the Catalog


1. In SAP HANA Studio, switch to the Systems tab.
2. Select your SAP HANA system, expand Security->Users, and double-click the user who is going to log on SAP Lumira Server. 
3. Go to Application Privileges, and search for the application you created in the previous step.

4. Add this application to the user privileges.

5. Activate the change by selecting the green deploy arrow.

Ensure the user has rights on the catalog you created

Your new catalog is created, but you must grant a user the right to use the catalog. Use SAP HANA Studio to select an appropriate user role, then give the role permission to use the catalog you created.

For more information, see To assign catalog privileges to roles in  the SAP Lumira Server Installation Guide at http://help.sap.com/boall_en/

View the category tile in SAP Fiori

Use a user account that has a role with the rights to view the catalog you created.


1. Launch SAP Fiori by entering the following URL in a browsher:

2. Log in with the user who has rights to the application and rights to the catalog, as described in the previous step.


3. On the SAP Fiori home page, you will see your new catalog tile.

  • The counter shows you how many stories  have a title that contains <SEARCH_STRING>.

4. Open the tile and the list of stories in your category is displayed.

Note: if you do not see the tile, ensure the user account has the right to view the catalog.

Additional information

  • To create additional tiles, you can re-use the same project and application site.  Start the procedure at the step Create a Catalog.
Former Member