In this CAR Tip in a Minute, I will explain how to create a SAP Smart Business KPI tile in the SAP Fiori Launchpad.

The SAP Fiori analytical applications delivered with SAP Customer Activity Repository use SAP Smart Business tiles as opposed to static SAP Fiori tiles for three main reasons:

  1. SAP Smart Business tiles allow for dynamic data to be displayed. This is in contrast to a static SAP Fiori tile which can only display static data. The SAP Smart Business tile also allows the user to navigate to the application with object/action semantic options.
  2. SAP Smart Business tiles allow for high flexibility and customization via the configurable input parameters consumed by the application’s SAP HANA views.
  3. Multiple SAP Smart Business tiles can be created with the same evaluation.

Prerequisite

The front-end user must have been granted the necessary roles. For more information on the authorization roles required, see http://help.sap.com/car -> SAP Customer Activity Repository 2.0 FP1 -> Application Help -> Additional Content -> SAP Smart Business for SAP Customer Activity Repository.


Procedure

  1. Select the “Create KPI tile in the SAP Fiori Launchpad./wp-content/uploads/2015/09/1_788577.png
  2. Enter the data for the Parameters section  as follows:/wp-content/uploads/2015/09/2_788578.png
    1. The ID will be the one that is given to the tile you are creating. This cannot be changed after this screen is confirmed. The default can be kept or you can select another ID.
    2. The Title will be the name and label of this KPI.
    3. Choose Additional Languagesto provide translations for the title
    4. The other attributes in the Parameters section are optional.
  3. Data Source section of this page provides the necessary information for the data source for the data presented in the tile.

/wp-content/uploads/2015/09/3_788582.png

  1. The SAP HANA view that you provide is consumed by the tile content. The views should be entered in the SAP HANA View field, based on which application this tile is being created for. For example if you are creating the KPI for Net Sales, you will enter the view NetSalesCurPerdQuery.

Application

SAP HANA View

Net Sales

NetSalesCurPerdQuery

Gross Margin

GrossMarginCurPerdQuery

Number of Transactions

NumberOfTransactionsCurPerdQuery

Items per Transaction

NumberOfSlsItemsPerTransCurPerdQuery

Average transaction value

AverageTransactionValueCurPerdQuery

  1. Once you have entered the SAP HANA View, when you click on the other input boxes, the correct value will be loaded automatically except for the entity set
  2. The OData Service you specify is the HANA XS OData service used to retrieve the data.
  3. The Entity set provides the data structure for the OData service. You will have to enter the correct value here as it is not loaded automatically based on the following table:

Application

Entity Set

Net Sales

NetSalesCurPerdQueryResults

Gross Margin

GrossMarginCurPerdQueryResults

Number of Transactions

NumberOfTransactionsCurPerdQueryResults

Items per Transaction

NumberOfSalesItemsPerTransCurPerdQueryResults

Average transaction value

AverageTransactionValueCurPerdQueryResults

  1. The Value Measure specifies the data source for the number that will be displayed on the tile.
  2. The Semantic Object/Action must be provided to determine what happens when a user clicks on the tile. The object is specified first and the action is specified in the second box. These fields specify the navigation target. The following data should be entered based on the application for which tile is being created.

Application

Semantic Object

Semantic Action

Net Sales

NetSales

displayMCSANetSales

Gross Margin

GrossMargin

displayMCSAGrossMargin

Number of Transactions

NumberOfTransactions

displayMCSANumberOfTxn

Items per Transaction

ItemsPerTransaction

displayMCSAItemsPerTransaction

Average transaction value

AverageTransactionValueCurPerdQuery

displayMCSAAverageTransactionValue

  1. Choose Activate and Add Evaluation.
  2. For more information on SAP Smart Business KPIs, see the SAP Help Portal

You will now enter the information required for creating the evaluation.

  1. Enter the Descriptive parameters. Only the Evaluation ID and title is mandatory./wp-content/uploads/2015/09/4_788583.png
  2. Enter the information in the Data source section. Again the SAP HANA view entered should be the same as when the tile KPI was created. The value for the other fields (OData Service, Entity Set, Value Measure, Semantic Object and Action) will be displayed automatically taken from the KPI data entered earlier.

/wp-content/uploads/2015/09/5_788584.png

    1. The Scaling Factor and Decimal Precision fields can both be set to “auto ”. The scaling factor specifies how the KPI value is displayed (for example, whether the value is expressed as thousands, millions, and so on). The decimal precision specifies the number of decimal places to show in the results.
    2. Enter the input parameters and filters:/wp-content/uploads/2015/09/6_788585.png
    3. De-select the P_SAPClient checkbox for Session Client and enter the Session Client value required. Note that it is necessary to provide the correct SAP Client (SAP MANDT), otherwise the results displayed may be incorrect./wp-content/uploads/2015/09/7_788586.png
    4. You will now fill out the Target, Threshold and Trend section:
      1. Change Value type to “Measure” to then enter the field names
      2. Enter the information in the Target, Warning, Thresholds, reference value and trend sections based on this table. This allows for the color coding that appears in the tile

      Red: value < critical
      Green:  value > target
      Orange: critical < value < target

           e.   The Trend is used to determine if the trend is going up or down based on the reference value, two parameters that you must enter.

Application

Target

Warning

Critical

Reference Value

Trend

Net Sales

PreviousPeriodNetSales

PreviousPeriodPartialNetSales

PreviousPeriodPartialCriticalNetSales

PreviousPeriodPartialCriticalNetSales

CurrentPeriodNetSales

Gross Margin

PreviousPeriodGrossMargin

PreviousPeriodPartialGrossMargin

PreviousPeriodPartialCriticalGrossMargin

PreviousPeriodPartialCriticalGrossMargin

CurrentPeriodGrossMargin

Number of Transactions

PreviousPeriodNumberOfTransactions

PreviousPeriodPartialNumberOfTransactions

PreviousPeriodPartialCriticalNumberOfTransaction

PreviousPeriodPartialCriticalNumberOfTransaction

CurrentPeriodNumberOfTransactions

Items per Transaction

PreviousPeriodNumberOfSlsItemsPerTransaction

PreviousPeriodPartialNumberOfSlsItemsPerTransaction

PreviousPeriodPartialCriticalNumberOfSlsItemsPerTransaction

PreviousPeriodPartialCriticalNumberOfSlsItemsPerTransaction

CurrentPeriodNumberOfSlsItemsPerTransaction

Average Transaction value

PreviousPeriodAverageTransactionValueInDisplayCrcy

PreviousPeriodPartialAverageTransactionValueInDisplayCrcy

PreviousPeriodPartialCriticalAverageTransactionValueInDisplayCrcy

PreviousPeriodPartialCriticalAverageTransactionValueInDisplayCrcy

CurrentPeriodAverageTransactionValueInDisplayCrcy

    

Next we will need to configure the tile that will appear in the SAP Fiori Launchpad for this application.

  1. Choose Activate and Configure Tile.
  2. For more information on adding evaluations to a KPI, see the SAP Help Portal.
  3. /wp-content/uploads/2015/09/9_788588.png
  1. Fill the “Add Tile” configuration screen:
    1. The Tile Configuration should be filled out as follows:
    2. Tile Format: Numeric Tile
    3. Title (KPI): This will be the title of tile, as displayed in the Fiori Launchpad (blue label in tile displayed below)
    4. Subtitle (Evaluation): The subtitle for tile that will appear in the Fiori Launchpad (green label in tile displayed below)/wp-content/uploads/2015/09/10_788589.png
    5. Finally, the Drill-Down selected should be “Other Drill-Down”, and make sure to select “others” under the Select Drill-Down field.
    6. The action and Semantic Object will be the same as when the KPI was created.
  1. Choose Save and Activate.
  2. We now need to add the authorizations to the users which are to have access to the tiles.
  1. Select the Manage KPI authorizations tile/wp-content/uploads/2015/09/11_788590.png
  2. Choose Authorize Users and Roles.
    1. Select the users and roles you want to authorize and click Save:/wp-content/uploads/2015/09/12_788591.png
    2. Finally, all that is left to do is add the tiles to the SAP Fiori Launchpad:
  1. Click the pencil icon in the SAP Launchpad:/wp-content/uploads/2015/09/13_788592.png
  2. Press the + button to add the Tile
  3. The tiles for which you have authorizations for will appear and you can add them by pressing the + sign below the tile:

/wp-content/uploads/2015/09/15_788594.png

You should now see the tile in your SAP Fiori Launchpad.

You can repeat the steps outlined 4 additional times, one time for each application, each time entering the data corresponding to that application. After completing this you will find the 5 applications in the SAP Fiori Lauchpad as follows:

/wp-content/uploads/2015/09/16_788595.png

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