nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Janardhan_Deo

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 .

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

Find more posts tagged with

Submitted

patch

OTBI

Status: Submitted

Comments

Baishali Nath

Screenshot 2023-05-27 013330.jpg

Hope this helps

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