BIP Audit report from metadata for Labels/Prompts for OTBI reports — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

BIP Audit report from metadata for Labels/Prompts for OTBI reports

Submitted
11
Views
1
Comments
Janardhan_Deo
Janardhan_Deo Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

 Hi Oracle BI Team,

 Can you share please below information. 

1.Need a query or a BIP Audit report for metadata which will be able to give us the information related to prompts or labels used for any subject area .

Or

2.The Table Name where the prompt/labels are stored and how we will get an access to query the table.

This is important to identify the changes in Labels/Prompts because of any Oracle Patch.

Thanks,

Janardhan

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • Baishali Nath
    Baishali Nath Rank 1 - Community Starter
    edited May 27, 2023 12:34AM
    Screenshot 2023-05-27 013330.jpg

    Hope this helps

    1. Login with a user having BI Admin role.
    2. Go to Analytics
    3. Click on My Profile --> Administration
    4. Under Manage Catalog Caption click on Export Caption
    5. A prompt appears. In the prompt give the folder name for which you want to download OTBI
    6. This will download all the metadata details of objects inside the Folder in an .xml format
    7. You can then open the XML in excelexcel