We have lot documentation available in SCN and Fiori App help guide in order to configure the Analytical apps. However, it is bit difficult for Fiori fresher’s to understand where/how to start the configuration. So I have basically listed out all important steps in Analytical App configuration in addition to standard SAP help documents. This is not replacement of any of those documents, only intention is to make you to understand the concept during initial stages and build the Fiori Analytical configurations easily.
2. Fiori Architecture:
Image Source – SAP Help website
As shown in the above diagram, Analytical App related KPI artifacts are available in HANA XS Engine. Fiori launch pad will distinguish whether it is transactional app or analytical app through web dispatcher by using URL semantics. Hence Web dispatcher will play major role to distinguish the client calls based on URL mappings and divert the call directly to Hana XS Engine in case of any analytical app.
In general, Basis Administrators will configure the webdispatcher and build the initial system. In case of any issue webdispatcher, basis will be go to team for help.
3. How to start Analytical App Analysis:
All analytical tile configurations will be done in Fiori launch pad directly by using KPI Modeler tiles and we won’t use Fiori Launchpad designer for this activity. So we have to first check whether KPI Modeler tiles which are shown below are appearing in Fiori launch pad or not.
If these tiles are available, then we need to proceed with KPI configuration, otherwise, we need to work with security team to get the correct roles assigned to user ids in HANA DB.
a. Prerequisite Roles for KPI Modeler:
- You have installed the SAP Smart Business modeler apps on the front-end server and on the SAP HANA server.
- Your front-end user is assigned the PFCG role /UI2/SAP_KPIMOD_TCR_S.
- Your SAP HANA user is assigned the roles
Security team has to assign these roles to Fiori developer, then he will get all the above tiles in his Launchpad to configure KPI Modeler related tasks.
b. Few general issues:
Sometimes, we can see KPI modeler catalog in launch pad, but we can see cannot load tile error which is shown in the below image.
This might happen due to either webdispatcher has not been configured by basis properly or any other required authorizations are missing out for user id.
So when ever, we will get this error, we need to check whether launchpad is asking the HANA DB credentials or not while logging , i.e., are you using correct Web dispather launch pad URL or not & then reach out to Basis team to check the web dispatcher settings.
If you won’t find any issue with webdispatcher, then work with Security team to get the required roles assigned in HDB.
Once everything is fine, we can able to see all KPI Modeler tiles, then we need to proceed with KPI configurations.
4. KPI configuration:
We can see all standard KPI IDs in KPI Workspace tile. As per our requirement, we have to activate the required tiles. As recommended by SAP,, we should not disturb any standard KPI ID and need to copy the standard KPI ID into customer name space and then create evaluation & drill downs by referring the standard KPI configurations.
a. Understand the KPI ID
Days Beyond Terms
Above is Days Beyond Terms Fiori app KPI ID. As per this KPI id naming conventoin, we should come to know about HANA artifacts name space.
The above shown path is the package hierarchy for this app and all app relevant HANA artifacts are available under this package. This is very important to understand when we will create custom KPIs, it’s better to name the custom KPI id as similar to standard naming convention which is shown above.
As per SAP Best practices, we have to copy the standard KPI ID to customer namespace and complete all the required KPI configurations according to APP guide.
b. Understand the Evaluation
Each KPI id is associated with evaluation. An evaluation is a combination of filter settings and input parameters (the variant), thresholds, parameters, trends, and authorizations related to a KPI that defines what can be seen by the SAP Smart Business user at runtime.
Technically, we can give all HANA XS Odata service name, entity type details, calculation view details, parameters and filter values in evaluation and save & activate it.
c. Create Tile
Once evaluation activated with out any errors, then proceed with Tile configuration.
All Tile details should be given as per the Fiori App guide or standard APP Tile configuration.
d. Drill down configuration
The generic drill-down application consists of one or more detail views of a KPI that are displayed when you click the KPI tile or when you click and select a chart or table object. It reads attributes from the KPI evaluation and details about the UI from the visualization.
We basically configure attributes, measures & representation type (chart/table/PI chart etc) in the drilldown configuration.
5. Catalog Assignment in Designer
All analytical tiles are assigned to Standard catalog /UI2/SAP_KPIFRW5_TC_R. Hence we no need to assign any tile in the catalog.
6. Group Assignment in Designer
Subset of catalog that contains the apps visible on the SAP Fiori launchpad entry page. Which tiles are displayed on a user’s entry page depends on the group assigned to the user’s role. In addition, the user can personalize the entry page by adding or removing apps to pre-delivered groups or self-defined groups.
Select required group in designer and search for the standard catalog /UI2/SAP_KPIFRW5_TC_R which has all KPI related tiles. Mark required tile and add it to group.
7. Security Role Assignment
- Roles (PFCG): Contains references to catalogs and groups and provides users with access to the apps in these groups and catalogs.
- Provide the catalog and group ids to security team, then they will assign them in the required business roles and assign it to users.
- Security team has to assign all business roles as per the Fiori App guide to users in order to access the apps correctly.
8. KPI Artifacts Transport
SAP Tool: SAP has provided SMART Business Download Tool, which enable to download all KPI artifacts into .csv file and upload them in the required system. But Web IDE tool is prerequisite to use this tool. Since we don’t have web ide tool in our landscape, I have not explored much on this tool, but many details are available in SCN and SAP help site.
- In latest S4 Hana Stack, SAP has provided an option to add tiles, catalogs and groups to transport request in KPI Modeler it self. You can explore more details on this approach in SCN.
- Whenever any changes being done in oData Metadata then always execute the below T-codes to clear cache in HUB and back end systems.
2. In case if BSP application updated or custom BSP application uploaded in SAP system, then
execute the below programs in SE38 to clear cache.
3. In addition to above, user has to clear the browser cache or execute the apps in Chrome incognito window.
4. Whenever tile not loading message appearing in launch pad, then re-check the targetmappings configurations in the respective tile in Launchpad designers.