Thursday, January 31, 2013

[OBIEE 10g] MetaData Dictionary


  
OBIEE MetaData Dictionary



The metadata dictionary is a very powerful support package within OBIEE. This article describes the configuration and implementation of the OBIEE metadata dictionary both on an OC4J and an IIS web services. (Other web services can be easily configured based on this)



Prerequisites


The account used for implementing this functionality must have full access to:



·         The source repositories

·         The Presentation server.

·         The Web server.




Generating the metadata dictionary


Open the repository in Offline mode:





Go to tools utilities:







Select Generate Metadata Dictionary: 





Select a destination directory:





On successful finish you will get:





If you are replacing you might get this:





Navigate to your {OBIEE MetaData Dictionary}\ {repository_name}





Open NameIndex in a browser to check the readability.





Open TreeIndex in a browser to check the readability.







OC4J Prerequisites


First we have to tell the presentation server where to find the dictionary. This is configured in the INSTANCECONFIG.XML file. Usually this file is found in



{OracleBIDate}\web\config.

Open the file and add:

<SubjectAreaMetadata>

<DictionaryURLPrefix>/analytics/dictionary/</DictionaryURLPrefix>

</SubjectAreaMetadata>

between the <WebConfig> tags. 








WOW: Some OBIEE config tags and the contents are CaSe SeNsItIvE!




OC4J web server


Create the “dictionary” directory in the analytics application folder:





Usually {OracleBI}\oc4j_bi\j2ee\home\application\analytics\analytic.



(it’s the folder where your SAW.DLL is located).



Copy the content of your dictionary export folder to this folder:





Restart the presentation server





Log in as administrator in answer, select the subject area:





Click on the dictionary symbol:









ISS Prerequisites


Create a new virtual directory in your IIS manager





Add the virtual directory to your INSTANCECONFIG.XML. Usually this file is found in {OracleBIDate}\web\config.


<SubjectAreaMetadata>

<DictionaryURLPrefix>/analyticsDictionary/</DictionaryURLPrefix>

</SubjectAreaMetadata>






Some OBIEE config tags and the contents are CaSe SeNsItIvE!


Restart the presentation server





Log in as administrator in answer, select the subject area:





Click on the dictionary symbol:





Granting access to the metadata dictionary


Log in as administrator  .Go Settings > Administration





Select manage privileges:





Select access to Metadata Dictionary













1 comment: