Essbase Modelling in OBIEE Admin Tool

    Make sure you have all the pre-requisites setup for connecting the Admin tool to Essbase server/client.

        Import the cube you want selecting Essbase as connection type and entering other details as shown:

1   Once you click on Next, It will displays the Essbase Cubes under the server

       Once the cube is imported the Dimensions and Facts appear in the Physical layer.

      To display all the Measures or facts in Essbase Cube,

Right Click Database [Basic] of Sample Application -> “Convert Measure dimension to flat measures”;

Note: No need to create again star schema, OBIEE will brings all join relationships along with tables! Also, Hierarchies, ragged or skipped are automatically handled by OBIEE.

As you can see from the screenshot below, the Market physical dimension has three UDAs associated with it; Major Market, Small Market and New Market.

We can also observed here it will display the Intro Date, Caffeinated attribute dimensions as hierarchies

3. Now Drag the Sample Cube from Physical to BMM layer and rename its object values if necessary.

         Drag the Business Model to the Presentation Layer and make any naming convention changes as per the business requirement.

        Check Global Consistency and Deploy in the Enterprise Manager.

        Check results by creating Analysis.