SAP Smart Business is a framework for exposing strategic (key) and operational performance indicators (KPIs, OPIs) as Fiori applications without the need to write any code. It can be used by customers, partners and SAP’s development teams for making highly aggregated analytical data accessible via Fiori Launchpad tiles.

Smart Business is released in various flavors depending on the underlying technology platform. Specifically there are the following separate Smart Business shipments:

  • Smart Business for Suite on Hana (SoH) delivery
  • Smart Business for S/4Hana delivery
  • SAP Smart Business in HANA Cloud Platform as a service (Beta Release)

Important documents and notes:

Help document on SAP Smart Business in Suite on HANA (SoH):

http://help.sap.com/ssb

Overview of SAP Smart Business Cockpit for Suite on HANA (SoH)

How to create KPI, Evaluations and Tiles

Release notes:

2018360

2183947

Smart Business Transport Tool:

http://scn.sap.com/community/fiori/blog/2016/07/27/smart-business-transport-tool

Smart Business KPI Modeler – “Cannot Load Tile” Error

In this article, I will discuss about the steps that need to be followed while re-deploying HDBTI objects.

To re-deploy the HDBTI files, follow the below mentioned steps:

1.      Go to your HANA database.

2.      Select your system and select the SQL option on top.


10.PNG

3.   Now run the following query in the SQL window :

select * from “_SYS_REPO”.”ACTIVE_OBJECT” where object_suffix = ‘hdbti’ and object_status > 0;

This query returns the result of broken HDBTI objects in your system, if any.


/wp-content/uploads/2016/08/11_1006410.png

In this example, the query returns some results. Go to step 4.

If the query does not return any result, it means all the HDBTI files are properly activated in your HANA database. If you are still facing the “Cannot Load Tile” issue with the KPI modeler tiles, go to Smart Business KPI Modeler – “Cannot Load Tile” Error


4.   If the above query returns some result, run another query to find out which packages have you installed in your system that contain the HDBTI files.


select distinct(package_id) from “_SYS_REPO”.”ACTIVE_OBJECT” where package_id like ‘sap.hba.%’ and object_suffix = ‘hdbti’


7.PNG

5. To re-deploy the HDBTI files, you need to re-deploy all the HDBTI files together (even if they are present in different packages in your HANA system.)

In this example, we will select the HDBTI files contained in both the packages (sap.hba.r.sb.core.db and sap.hba.apps.sofm.s.db) and deploy them together.

NOTE: It is important to re-deploy all the HDBTI files and not just the broken HDBTI files. This is because of the dependencies of the components on one another. If even one of the HDBTI files is left out, the re-deployment will fail and you will keep getting “Overlapping key” error.

6.  Open the HANA system in HANA modeler View.

Go to Window -> Open Perspective -> SAP HANA MODELER (might be present in the “Other” option).

This will open the HANA modeler View for you where you can perform actions on the database files.

7. Go to the “Systems” tab of the HANA Modeler View and open the path to the HDBTI files contained in the packages.


8.PNG

In this example, we have opened the path to the HDBTI files contained in the packages sap.hba.r.sb.core.db and sap.hba.apps.sofm.s.db.

8.  Now, go to the “Redeploy” option contained HANA Modeler View in the Quick View Panel.


12.PNG


  Select the system and then select the path to all the HDBTI files contained in various packages till you are able see the HDBTI folder in each of these paths.


9.PNG


In this example, we have opened the path to the HDBTI files contained in the packages sap.hba.r.sb.core.db and sap.hba.apps.sofm.s.db.

10. Once all the HDBTI files are chosen, click on “Add”.


11. Confirm that all the HDBTI files have been selected.

12. Click “Next” and then “Redeploy”.

13.  Wait for the re-deployment to finish.

14. If the re-deployment is successful for all the files, all the HDBTI files will be get activated in your system.

15.  If you face an error like “Overlapping key issue”, it means you have left out some HDBTI files while re-deploying. Kindly deploy again.

16. If you face an error like “23 22 column mismatch” or “22 23 column mismatch”, it means that there is some issue with the compatibility of the installed Smart Business components. Kindly follow note #2125939 for further details.

I hope this article is able to solve the issue of broken HDBTI files for you 🙂








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