Thursday, 20 January 2022

OBIEE : Catalog Manager Report Run Through Command line

 Below is the syntax to run catalog manager report through command line. 

./runcat.sh -cmd report -offline CATALOG_PATH -outputFile EXPORT_REPORT_PATH/File.csv

-delimiter ";" -type "Analysis" -fields "Col1:Col2:Col3"

Example:

./runcat.sh -cmd report -offline /u01/BIUAT/OBIEE/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/OracleBIApps -outputFile /u01/BIUAT/OBIEE/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/export_object_names01.csv -delimiter ";" -type "Analysis" -fields "Name:Created:Modified:Path:Subject Area:Table:Column" 


Happy Learning !! 

No comments:

Post a Comment

Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps. 1. Open Report Query Editor Mode. 2. Clink on Get Data -> Blank...