Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11.1.1.6 catalog manager for extracting webCat_dashboard_text.txt

Received Response
1
Views
5
Comments
User_8OQQN
User_8OQQN Rank 1 - Community Starter
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

Hello,

I am trying to extract the webCat_dashboard_text.txt from Catalog manager to create the reporting lineage which is part of the ODI Data lineage in ODI 11.1.1.9. Oracle docs says to use 11.1.1.6 to create a report of the catalog, but I just can't seem to find a place to be able to download OBIEE 11.1.1.6 at this point. Does anyone know where I can get it?

Oracle e-delivery has OBIEE 11.1.1.9 but not 11.1.1.6.

Or if there is a workaround to getting that webCat_dashboard_text.txt from 12g or 11.1.1.9 OBIEE?

Thank you.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    11.1.1.6 is out of support and you won't be able to get the Administration Tools anymore - maybe through raising a Service Request.

    That said the Catalog Manager is nothing but a GUI on top of the runcat.sh/.cmd and you can do everything via command line as well.

    I take it you are referring to this? https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-7C5492C6-CB1A-417B-B7DA-1C9FA00B38F1.htm#BIASA24677

    So just run "runcat.cmd//runcat.sh -help" to get a list of all commands.

    Then run "runcat.cmd//runcat.sh report -help" to get the detailed description of how to use the "report" command in detail.

  • User_8OQQN
    User_8OQQN Rank 1 - Community Starter

    Thanks for the quick response Christian. Yes that is what I am referring to.

    I have been running this script against the OBIEE 11.1.1.9 runcat.sh as shown below, I gave it two child types "Dashboard Page:analysis" and it seems to returns just one set of child fields. I went to read the help as you suggested and I am realizing that it only does the analysis and dashboard as child types. How do I get the dashboard page in that case? Because in the GUI, dashboard page does not have any child types.

    ---

    RUNCAT_PATH=....../OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager
    CATALOG_PATH......./OracleBIPresentationServicesComponent/coreapplication_obips1/catalog
    CATALOG_NAME=SampleAppLite
    CATALOG_FOLDER=/Shared
    HOME_PATH=/home/....

    cd $HOME_PATH

    sh $RUNCAT_PATH/runcat.sh -cmd report -offline $CATALOG_PATH/$CATALOG_NAME -forceOutputFile $HOME_PATH/webCat_Dashboard_text.txt -delimiter \",\" -distinct -type "Dashboard" -fields "Owner:Folder:Name:Path" -childrenType "Dashboard Page:Analysis" -childrenFields "Name:Path"  > $HOME_PATH/webCat_Dashboard_text.log

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Hi -

    You should be able to use the 11.1.1.7 catalog manager. https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-7C5492C6-CB1A-417B-B7DA-1C9FA00B38F1.htm#BIASA24677

    Try this: https://edelivery.oracle.com

    Then, search for 'Oracle Business Intelligence Developer Client Tool 11.1.1.7.0'

    Regards,

    Charles

  • User_8OQQN
    User_8OQQN Rank 1 - Community Starter

    Thanks a lot Charles M. It works. Earlier I had tried this using OBIEE 11.1.1.7.14500 and found that it did not have the same GUI, apparently the catalog has been updated to what it is now in the update from 11.1.1.7.0 to 11.1.1.7.1.

    I will figure out how to use the runcat.sh to automate this report generation.

    Thanks.

  • Charles M
    Charles M Rank 6 - Analytics Lead

    You're welcome. Glad it is working for you!

    Earlier I had tried this using OBIEE 11.1.1.7.14500 and found that it did not have the same GUI, apparently the catalog has been updated to what it is now in the update from 11.1.1.7.0 to 11.1.1.7.1.

    Interesting ... good catch on that version number!

    Also, one more thing about these files. When I did this I got an error during the data lineage ETL (I'll see if I can dig up the specific error message). But, basically, it was expecting different names for these files.I was using OBIA 11.1.10.1 [OBIEE 11.1.1.9.3], so this may/may not happen to you ...

    Save the file as webCat_dashboard_text.txt in a local folder

    I believe this needs to be named ‘WebCat_dashboard_text.txt’ (note the capital letter ‘W’)

    Save the file as webCat_text.txt in a local folder.

    I believe this needs to be named ‘WebCat_text.txt’ (note the capital letter ‘W’)

    Regards,

    Charles