Business Intelligence – Oracle

Oracle BI EE – Metadata Dictionary Statistics

Posted by Venkatakrishnan J on August 23, 2007

One of the new features of Oracle BI EE is the ability to view the Metadata Dictionary Statistics from within BI Answers.
“In this release, this Metadata Dictionary can
now be accessed directly from the Oracle BI Answers selection pane where specific metadata information will be shown to guide report construction. Once this Oracle BI
Answers-based functionality has been enabled as described in this section, an icon will appear next to each Subject Area, Table name, and Column shown in the selection
pane for that Subject Area. The Subject Area icon is always displayed, whereas the Table name and Column name icons are only displayed on mouse-over. Clicking on the
icon will open up a specific Metadata Dictionary page to show information for that element and links to related repository information.”
– This is what the documentation says about this feature.

Lets see how to go about doing the same here. The first thing you would have to do is to open your repository in offline mode using the Administrator. Then go to
Tools->Utilities->Generate Metadata Dictionary and click on Execute.


Then it would prompt you to specify the directory wherein you would like to have the dictionary exported to. Specify any directory here. We can later on copy the files later on. Once executed,
utility would create dictionary under a new folder with the name same as the repository. In my case i have create the dictionary for the repository called Paint. It would look something like this below


The dictionary is nothing but a set of static xml files that gives lineage information of the metadata. Once the dictionary has been created the next step is to bundle this and deploy it into the App server.
If you have a OC4J instance copy all the entire paint directory to the directory where you would find the saw.dll file (this is where the analytics war file would have been deployed). Once this is done
restart the presentation services and ensure that you can access the xml files directly. Your URL would look similar to this http://localhost:port/analytics/paint/NameIndex.xml .


Ensure that you do get the xml back after entering the URL. Once this is done, the next step is to make BI Answers aware of the presence of the dictionary. To do this open InstanceConfig.xml file.
It would be under {BIEEDataHome}/web/config. Then add the following to the file


Save this file and restart your presentation services. Now if you open Answers, you can find a small icon next to the subject areas and the columns that would directly take us to the corresponding metadata dictionary.


This is available in the documentation here. But the doc does not specify the details for OC4J or Oracle App server.
I believe this should help you out in case you are planning to implement it in your org.

9 Responses to “Oracle BI EE – Metadata Dictionary Statistics”

  1. Subhojit said

    I have done the steps above, but somehow when I try http://localhost:port/analytics/paint/NameIndex.xml with the proper localhost name and port, I am still not able to see the files though they are present there. Can you suggest what can be the reason? The services that are running are Presentation Server,BI Server and Java Host. It would be a great help if you can comment on this.


  2. Venkatakrishnan J said

    I believe you are on the latest release Do you use the default OC4J or have you deployed BI EE on any application server? Did you restart the presentation services? If this does not work can you try restarting the OC4J itself. Can you also let me know in which directory you have placed the dictionary?

  3. olapguy said

    The doc says Access to Metadata Dictionary privilege, any ideas on how to set this. I have been unable to find anything.

  4. olapguy said

    I found it. You then need to add the privledge via the Oracle BI Presentation Services Administration -> Manage Privledges and grant Access to Metadata Dictionary to everyone. It is not a security group in the Admin tool for the rpd, or in security there, simply in the web catalog.

  5. daniel said

    Mr… you rock!
    This feature is what we call, a killer feature.
    Some friends are jealous now, they want the same on OWB!

    Wonderful tutorial, I’ll enjoy adding this to my project.

  6. Roy said


    Is there anyway to apply security to user who have only access to the subject areas. User who click into the subject can drill into the business Model layer and from there they have access to to all logical folders, not just those associated with the subject area they originally click through.



  7. damo said

    I noticed that for the version, the utility ‘Generate Metadata Dictionary’ is appearing only for the Vanilla rpd. The utility doesnot appear for the custom rpds. I expect it to be present since I presume this is part of AdminTool functionality and not rpd functionalilty (like Projects). Kindly clarify

  8. Sofiane said


    I have a question about the DAC Repository. I’m trying to find which tables are used by the DAC.

    Also there is a new staff in OBI version (DAC 7.9.4) within the DAC Server there is new execution Plans Called Data Lineage. Do you have any information or documentation about this new features !!!

    Thanks in advance

  9. gud said

    I have done the steps above, but somehow when I dont get http://localhost:port/analytics/paint/NameIndex.xml with the proper localhost name and port, Can you suggest what can be the reason? The services that are running are Presentation Server,BI Server and Java Host. It would be a great help if you can comment on this.

    I am using obiee I use the default OC4J ,I restarted the BI Server, presentation services, OC4J also. I placed the dictionary at

    Any suggestions will be greatly appreciated

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: