
Many a time I have worked on MTM and gone through many blogs, however I have never found the information about updating Database information for Crystal Reports.
We deal in the Airline industry wherein we provide the sets of standard reports to all of our clients. These sets of standard reports contain Crystal Reports. We use MTM to create tenants on BI4.1 servers. After creating a tenant we copy the standard reports and manually update the database information for Crystal Reports. This was a time consuming and difficult process for us until we found a way of automating this process by using MTM.
I was really not sure whether it works or not until I tried it in our environments and it worked for us as expected.
This document will describe all the required steps to use MTM in BI4.1 environments. Here, we will create a new tenant and will update the Crystal Report's Database information. We will also apply the security to the tenant using a template. I have used BI4.1SP04 and Oracle 11G DB to test this on Windows 2012 server.
Before running MTM command we will create the required templates as below:
2. Create the user group templates:
3. Assign Access Rights as required on the template folders:
4. Copy the required Crystal Reports 2013 to one of template folders:
Now, we will configure the template configuration file:
This file can be found at the location: <BI installed path>\java\apps\multitenancyManager\jars\tenant_template_def.properties.
NOTE: Do not modify this file, take the backup and rename this file to the tenant name something like "TestMTM_def.properties". You can rename this file to anything you want. File name should always contain the string "_def.properties". I have renamed this file as "TestMTM_def.properties".
Here are the contents of this file:
NOTE: "crystalreport.templatedb" will be the database information of the crystal reports what we have in the template folders. "crystalreport.tenantdb" will be the database information of the new tenant which will be created by MTM. I have removed the DB information what I have used in our environments for this activity. If you have mutiple CR reports using multiple DB information then you would need to mention all of them in the following manner. We had only two DB information specified for all of the CR reports. We have to ensure that the BO server can communicate with all of the DB servers we are going to use in the following DB information.
E.g.
crystalreport.templatedb1=templateserver;templatedbname;odbc;administrator;password
crystalreport.tenantdb1=tenantserver;tenantdbname;odbc;administrator;mypassword
I have used following two database information in this file.
Let's discuss about how to specify this DB information for CR reports.
iii. templatedbname and tenantdbname => would be a database name if you have specified any on the CR reports as shown below highlighted in red.
iv. odbc => This would be a database server type, I have used oracle DB so I have mentioned oracle in the screenshot above.
Valid database server types are odbc, oracle, db2, sybase, informix, crdb_xml.
v. administrator;password and administrator;mypassword => This would be database usernames/passwords for the template and
tenant's CR reports.
vi. Save the properties file.
Time To Run MTM command:
Command: java -jar multitenancymanager.jar -configfile TestMTM_def.properties -tenantName=Test[PROD]
The output of the above command will be shown as below if everything goes well with MTM.
After the successful execution of the above command, it will create the following objects.
2. Created Folder Structure.
3. Copied all CR reports to the new folder "Test[PROD] Ad Hoc Reports".
4. Replicated access rights on the tenant's folders from template folders.
5. Updated DB information on the CR reports:
NOTE: You would find that all new CR reports are using Custom Database logon information.
Points To Be Noted:
Parameter: -XX:MaxPermSize=512m
Command: java -XX:MaxPermSize=128m -jar multitenancymanager.jar -configfile TestMTM_def.properties
Troubleshooting:
2. Logs will be generated the location "BOInstallDIR\SAP BusinessObjects Enterprise XI 4.0\logging" as multitenancymanager_XXXXXXX_trace.glf. This file can be opened using a notepad or notepad++.
3. You can also check the CSV file generated by MTM while creating a new tenant. This file would be created at the location what we have mentioned in the properties file, here it was "E:\BOADMIN". This CSV file will contain the information about all the objects which would be created during the creation of the new tenant.
4. Please check the KBAs: 1955167 and 2072040.
MTM Workflow:
More with MTM:
To Know More About MTM: Please refer this guide and following blogs.
Overview of SAP BI 4.x Multitenancy Management Tool by christina.obry.
Multitenancy Management tool setup, new features in BI 4.1 by sohelahmeds
To map/update Universes, Webi Reports and Connections using MTM in BI4.1, please refer to blog How To Use Multi Tenancy Management Tool(MTM) For Refreshing Web Intelligence Reports, Universes, Co...by swapnil.yavalkar14
I hope this document would be helpful. :smile: I am really not good with the formatting still I have given my best today :wink:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |