SMART Business Download Tool – KPI Modeler
Until recently, there was no option provided for transporting the KPI Modeler entries. This had to be done manually in all the environments. With the new SMART Business Download tool, its now possible to capture the KPI Modeler entries like KPI/Evaluations and transport them to other environments. There is not much documentation on how this can be done and I hope people find this useful.
Launch the tool using https://<hostname:port>/sap/hba/r/sb/transp/WebContent/index1.html (based on your version)
Ensure that you have package privilege and also roles like sap.hba.r.sb.transp.roles::SAP_SMART_BUSINESS_TRANSPORT.
Click on the “Select KPIs to Download all its Entities” and select those KPI’s which you are interested to download. Once this is done, provide a package where these entries will be uploaded to. I have created a new package “MyPackage.kpiModel” and referred it as the package. When you click on “Download Entities(csv and hdbti file formats)”, this should download multiple excel files along with a hdbti file. If this doesn’t work, ensure that the Multiple download file setting is enable in your browser. In Chrome > Settings > Advanced > Privacy > Content Settings and select “Allow all sites to download multiple files automatically”.
The below files will be available in your download folder
Launch the Web IDE editor using https://<hostname:port>/sap/hana/xs/ide/editor/
Locate the package which was created to hold the KPI Modeler entries and open it. Drag all the excel/hdbti files from the download folder into “Multi-file Drop Zone”. This will add the files in to the package.
Finally assign the package to a DU and follow the transport mechanism. Once the hdbti file gets activated in the target system, it would read all the entries in the excel files and upload them into the corresponding physical tables in HBA Schema.
Handling client dependent parameters provided in evaluations:
Almost in all KPI’s we had a parameter called SAP Client which was hard coded in DEV environment. Hence, transporting of KPI entries would mean the same client would be transported to Production. The clients are not always the same.
Hence, to deal with this, we put the Production client in DEV environment and captured the entries in a transport and pushed it all the way to Production.
After this, we executed the below SQL in all other environments manually. I am keen to hear from others how they got around with this problem.
Hello Murali,
Really a nice blog. Not much info is available on this topic.
One question, since we are not having the WebIDE, can we add the files to the package directly from the eclipse using the SAP HANA Development/Modeler perspective?
Rg,
Rahul Malani
Please create a new Discussion marked as a Question. Comments to a Blog (or Document) is not the right vehicle for asking questions as the results are not easily searchable. Once your issue is solved, a Discussion with make the results much more visible to others experiencing a similar problem. If a blog or document is related, put in a link.
NOTE: Getting the link is easy enough for both the author and Blog. Simply MouseOver the item, Right Click, and select Copy Shortcut. Paste it into your Discussion. You can also click on the url after pasting. Click on the A to expand the options and select T (on the right) to Auto-Title the url.
Thanks, Mike (Moderator)
SAP Technology RIG
Hi Murli,
After clicking download, where can I see the files?
-Bhavik
Hello Murli,
We manages to download the files from the migration tool and attached it to a package in our DEV system. But when we try to activate the KPI.HDBTI , we get the error saying Key Violation. Since this is not active, I am not able to move this to my QA system and see the evaluations that are present in DEV system. Can you please let me know if you faced this issue and how I can overcome this issue?
Thanks,
Vasu