This content has been marked as final. Show 4 replies
Use runcat.cmd from1 person found this helpful
If helps pls mark
The path is MWHOME\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\runcat.cmd
The command below will give you a report in excel format
runcat -cmd report -offline C:\middleware1\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite -outputFile c:\report.xls -excelFormat -delimiter " " -type "Analysis" "Column" "Table"
You can run runcat -cmd report -help to see more options.
Hope this helps.
I am able to get this done in the offline mode but i am facing diffucty in doing tjis in online mode. can you please specify how to give the user credentials to make this command work in online mode?
Hi,1 person found this helpful
You have to give the credentials in a file.
Create a text file called catmancredentials.properties
content of the file will be
login = <Username>
pwd = <Password>
then run the command as below
runcat -cmd report -online http://localhost:7002/analytics/saw.dll -credentials c:\catmancredentials.properties -outputFile c:\report.xls -excelFormat -folder "/shared/Sample Lite" -type "Analysis" "Created Time" "Last Accessed Time" "Last Modified Time" "Owner" "Description" "Folder" "Name" "Path" "Formula" "Table" "Column" "XML" "Subject Area" "SQL"
replace the output file and catalog folder as per your requirement.