You've attempted the importIMBiarFiles.bat/sh, but you can't import the following OOTB reports to BusinessObjects Enterprise Central Management Console, Home > Folders > IM Reports: (evolving list)
Best Practice: tiered deployment (IDMGR standalone and IM reporting standalone, not IDMGR and IM Reporting on the same node.)
<Please see attached file for image>src="/servlet/servlet.FileDownload?file=0150c000004AJypAAG" alt="Figure 1" width="598" height="341" border="0">
Please implement the following steps, clarifying the installation guide in order to import the BIAR file into IAM Report Server and underlying CMS Database.
BIAR File Location - use one of the following (depending on CMS DB type chosen):
Copy the biar file for your DB (MSSQL or ORCL) from the IM Server to the Report server.
This will be the path you'll utilize when prompted for the BIAR file location, within the importIMBiarFiles.bat.
BIAR Tool location (on IM Application Server):
Unzip the biar tool onto the Report server root drive,
The archive importbiarFilesTool.zip that was previously copied from IM Server, must be extracted directly into Root of the drive where you installed the report server (NO-SUBFOLDERS)
For example if you installed your report server on your %SYSTEM_DRIVE%, after unzipping you should have two new folders in C:
if you installed your report server on your E drive, after unzipping you should have two new folders in E:
Please ensure that your %JAVA_HOME% is valid within your set or modify file C:\import-biar-tool\importIMBiarFiles.bat to point to your Java installation, for example:
Please execute the \import-biar-tool>importIMbiarfiles.bat from cmd prompt.
Be sure to fill in the correct information,
For example: An Oracle CMS DB setup would look something like this:
***********Setting up the Reports Server details...
Enter Report Server root folder = C:\Program Files\CA\IAM Report Server
Enter Business object database type (1=MSSQL, 2=Oracle) = 2
Enter Business object database user = IM_REPORT
Enter Business object database password = ********
Enter Business object database TNS name = ORCL
Enter Business object system administrator's name(default "Administrator") =
Enter Business object system password(administrator's) = *********
Enter BIAR file location = c:\oracle_reports.biar
(Please note; single and double quotes aren't required for paths which contain spaces.)
When you are prompted with: Do you want to remove the BIEK Install properties file created by this tool, please answer NO.
This file can be used to invoke additional debug to assist support.
To enable debug please perform the following steps:
Subsequent imports can now be performed via the \import-biar-tool>importbiarfile.bat, which will automatically pull the information from biekInstall.properties within the import-biar-tool dir. (you don't need to retype all the info for Setting up the Reports Server details)
If required, please upload the following to your support issue:
You can verify that the tool performed it's job by logging into the CMC and/or Infoview and you should find the 'HOME' -> 'IM Reports' folder with the default OOTB IM Reports, which were previously mentioned above within the Summary of this technical document.