Skip to main content

Generate Metadata Dictionary in OBIEE 10g

Generating Metadata dictionary is one of the added advantage in OBIEE.  This allows the End User know about the added information of each column like data type, length, nullable and etc., 
A metadata dictionary is a static set of XML documents. Each XML document describes a metadata object, such as a column, including its properties and relationships with other metadata objects.
Here we are going to know how to generate metadata in OBIEE 10g.

In this post I have taken samplesales repository to generate its corresponding metadata dictionary. I am suggesting you people to take which repository you really need to generate metadata dictionary.

Step1: 
Open BI Administration Tool in Offline Mode -> Select 'Tools' Menu -> From dropdown option Select 'Utilities'
Below is the sample screenshot:
Step2:
Once we clicked Utilities, It will show the Utilities Window. From there select 'Generate Metadata Dictionary' and click 'Execute'

Step3:
Create a folder called 'Metadata in D: Drive and choose that folder in the choose Directory Screen

Step4:
Once we selected the target folder and clicked 'OK' with the above screen, It will generate the metadata dictionary folder in the name of repository. This process will take time depend upon the repository size. Once it is created metadata dictionary folder we will get confirmation dialog box like below:

Step5: 
Now go the D:\Metadata folder. There we can see the samplesales folder which is generated just before. Copy the 'samplesales' folder to the below location;
C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\dictionary
Note: Commonly the dictionary folder will not be available in the analytics folder. So create 'dictionary' folder into the analytics folder and copy samplelsales folder into that folder.

Step6:
Now open the instanceconfig.xml file from the location C:\OralceBIData\web\Config. Once we opened the file add the below code inside into the <ServerInstance> tag.
<SubjectAreaMetadata>
<DictionaryURLPrefix>/analytics/dictionary/</DictionaryURLPrefix>
</SubjectAreaMetadata>
Step7:
Now restart the following BI Services to apply the changes.
1. Start OC4j
2. Oracle BI Server
3. Oracle BI Presentation Server
After the service restarted, Login into the BI Presentation services. We can see the metadata dictionary beside to subject area /columns. It is shown in the red rectangle in the below screenshot:
Step8:
Click on the 'Metadata Dictionary' symbol. Refer above screen to see the detail. It will display the screen like below. Using this we could know the information about all tables, columns and its details.

Note: Security Changes
Like all other report privileges we can restrict the users who needs to be accessed about this Metadata Dictionary by changing the privileges in Administration -> Access -> Acces to Metadata Dictionary in Presentation Services Administration settings.
Cheers!
Bose

Comments

  1. I haue taken one excel file. it was below tepe

    Message Code Message
    TM_6014 Initializing session [s_m_Inc_CUSTOMER] at [Thu Sep 19 00:08:15 2013].
    TM_6683 Repository Name: [PRS_LEEYO-INFORMATI]
    TM_6684 Server Name: [PIS_LEEYO_INFORMATI]
    TM_6686 Folder: [revprobi_dev]



    it was imported in obiee11g
    but it was showing some errors while showing VIEW DATA




    ReplyDelete

Post a Comment

Popular posts from this blog

OBIEE 11.1.1.7.0 Step by Step Installation

This post will guide us through the  step by step installation of OBIEE 11.1.1.7.0. Here I don't find any difference in RCU installation between in previous version with this version. Still if you want to know the RCU installation stepsclick here
Step1: Download the OBIEE 11g versionfrom here or from oracle e-delivery site and extract all the four disk into a single folder and click setup.exe from the Disk1
Universal Installer window will start and will check for the initial set up and system requirement. After the successful precheck the first step of our OBIEE 11.1.1.7.0 starts with the below window. Just Click 'Next'
Step2:
If you have oracle Support username and password then update then use that in this step or just select first option 'Skip Software updates' and click 'Next'
Step3:
Select the appropriate installation step here. I am going to install all the component of BI so selected here 'Enterprise Install' and then click 'Next'
Step4:
This …

Step by Step Installation of Oracle 11g 64bit in Windows7 64bit

This Post will give you step by step information of Oracle database 11g 64 bit version installation in windows 7 64 machine. If you prefer with Oracle Database 11g installation in Windows 64bit machine, This post will help you to move forward.
Prerequisites Checks: RequirementMinimum ValuePhysical memory (RAM)1 GB minimum
On Windows 7 and Windows 8, 2 GB minimumVirtual memoryIf physical memory is between 2 GB and 16 GB, then set virtual memory to 1 times the size of the RAM
If physical memory is more than 16 GB, then set virtual memory to 16 GB
Disk spaceTotal: 5.39 GBProcessor TypeAMD64, or Intel Extended memory (EM64T)Video adapter256 colorsScreen Resolution1024 X 768 minimum
Download oracle Database from oracle site and unarchive the zipped download file.
Step1:  Just double click on setup.exe from the unarchived folder of oracle database source. Step2: Oracle Universal Installer will check the disk space and initiates the installation Step3: If you have a oracle metalink ID then type your em…

ADF_FACES-60097 : For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096: Server Exception during PPR, #1