Wednesday, December 2, 2015

Automatic Repository documentation in OBIEE 11g/12c



Please follow below steps for repository documentation for OBIEE installed in Linux machine and before trying this steps take a backup of your RPD.

1.Download BI desktop tools and save it in a desired location in a desired folder.

2.Next create a file and save it with ".build " extension. example report_doc.build

 Enter following commands in this file

OpenOffline C:\\
DescribeRepository C:\scriptoutput\repository_report.csv UTF-8

example:
OpenOffline C:\\SampleAppLite_BI0001.rpd XYZ
DescribeRepository C:\\repository_report.csv UTF-8
Close
Exit

3. In above command you can see that repository_report.csv is being placed in C:\ when command runs it places the output there. You can place output wherever you like just specify the correct path in above lines of code.

4. Please navigate to location where you installed BI desktop tools and go to following location C:\OBIEE\oraclebi\orahome\bifoundation\server\bin and search for bi-init.bat file and open it in edit mode in notepad and place following command line in the file above of last if statement.

C:\OBIEE\oraclebi\orahome\bifoundation\server\bin\AdminTool.exe /command C:\\report_doc.build

4. In the above command line as you can see report_doc is present in C:\ folder  you need to create the folder so that when command runs it finds the report_doc.build in that location. You can place report_doc.build wherever you like just specify the correct path in above lines of code.

5. Once all steps are done just go ahead and open the BI Administration Tool or BI Command Prompt. Now go and check on the location for output i.e. in above example C:\ you will find the csv file.


NB: You have to take the latest deployed rpd file by reading the NQSconfig.ini file and then place it in a location that is accessible by the Desk top tool if  you are going to automate this particular job and schedule it on a weekly basis.


 

1 comment: