OBIEE Metadata Dictionary in 11g


As seen in one of our previous blog articles “Step-by-step on how to generate a Metadata Dictionary”, sometimes you might need to make accessible to the users information about metrics or attributes from repository objects. It’s useful to check quickly this information when you’re developing or creating a report using only a web browser or when you don’t have permissions to access the repository.

A metadata dictionary is a static set of XML documents where each XML document describes a metadata object with its properties and relationships with other metadata objects. The metadata dictionary has to be generated each time repository changes are made.

In this article you’ll find a step-by-step guide to generate a Metadata Dictionary in OBIEE 11g. Continue reading this post >

Analytic Functions: Using LAG for SCD type 2


In one of my previous blog articles called ´´Deduplication using Analytic Function´´, I explained a simple introduction of Oracle Analytic Functions. In this article (addressed for SQL developers), I will focus on the LAG function which from my point of view, is one of the most useful functions. Let’s see the use of this function in a common Data Warehouse scenario: Slowly Changing Dimension.  Continue reading this post >

Blank schemas in BI Administration Tool when importing metadata



OBIEE ( demands having the full set of OCI libraries in order to import metadata successfully.  A couple of steps will guide you to install the missing libraries as well as configuring the tnsnames.ora file properly.

Import Metadata function in OBIEE Administration Tool uses the Oracle Call Interface for 10g and 11g.

The connection type uses a set of libraries installed during OBIEE. However, the full set of OCI libraries are needed while accessing to the database schemas. If any of those libraries is missing the schemas will be shown in blank:

Continue reading this post >

privacy policy - Copyright © 2000-2010 ClearPeaks