CODEWITHSUNDEEP
oracle-databaseoracle12cobieebi-publisher
Caleb
Caleb

Reputation: 359

How to access 12c report metadata?

I am looking for a method (or even better a DW table) that contains report properties such as Name, Description, Type, Location, etc.

I have looked through many tables but can not find this information. I am working to build out a web portal that includes hyperlinks for all reports on the server.

Here is an example of report properties I am looking for-

OBIEE report properties

Upvotes: 0

Views: 834

Answers (3)

EdHayes3
EdHayes3

Reputation: 1954

For what it's worth, in E-Business Suite, tables start with XDO_

Upvotes: -1

Chris
Chris

Reputation: 2752

Just to clarify the "lame" storage: What the OP is asking for is in the presentation catalog; the RPD has nothing to do with it. And to clarify even further: Every object stored in the presentation catalog is physically represented by two files on the disk: one file without file extension which represents the object's XML definition. And one file with an .atr extension which contains the object's properties - what the OP is looking for - as well as the object's access permissions. Ranting's fain, but please be precise ;-)

Upvotes: 1

Adam vonNieda
Adam vonNieda

Reputation: 1745

Unfortunately, the definitions you're looking for are not stored at the database level, which is super lame, but that's the way it is. They're stored in the RPD file and the web catalog at the OS level.

The webcatalog is located:

  • on 10G: OracleBIData/web/catalog/
  • on 11G: $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/catalog/

  • on 12c: $ORACLE_HOME\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog where ssi is a service instance.

    If you descend into one of those directory structures you'll see files that are named with a bunch of punctuation symbols, plus the name of the report they represent.

Reference 1 Reference 2

Upvotes: 1

Related Questions