Creating Oracle BI EE Dimensions

During Oracle BI EE connection creation, if you selected the Business Model option, Essbase Studio explores the source database for dimensions. From the dimensions that you select, Essbase Studio derives hierarchies, and the dimension elements that are included in the hierarchies, and adds them to the Metadata Navigator.

Note:

For information on how Essbase Studio generates key and caption binding expressions for the dimension elements that are created, see Rules for Generating Key and Caption Bindings for Oracle BI EE Business Model Dimension Elements.

  To create metadata elements that include dimension elements and hierarchies:

  1. In the Create OBIEE dimensions page of the wizard, in the Available OBI dimensions list, select dimensions to create metadata elements, including hierarchies and their related dimension elements.

    • Select the check box next to the data source name at the top of the Available OBI dimensions list to create metadata elements from all available OBI dimensions in the data source.

    • Select the check box next to only those OBI dimensions for which you want to create metadata elements.

    Dimensions you select are added to the folder for this data source in the Metadata Navigator.

  2. In Select OBI fact tables, select the tables to designate as fact tables.

    • Select the check box next to the data source name at the top of the Select OBI fact tables list to specify all fact tables candidates.

    • Select the check box next to only the fact table candidates that you want to specify as fact tables.

    Note:

    When scraping Oracle BI EE version 11.1.1.6 and later sources, the Select OBI fact tables panel will list only fact tables. Versions of Oracle BI EE older than 11.1.1.6 will list all tables (regular tables and fact tables).

  3. Optional: To store the metadata elements in a folder other than the default folder:

    1. Click Browse.

    2. In Select Folder, navigate to the folder in which you want to store the metadata elements, expanding the folders as necessary.

      Alternatively, click New Folder, enter the folder name in the text box, and click OK.

  4. Optional: Select the Create cube schema and Essbase model check box.

    Using the Oracle BI EE fact tables and dimensions, you can specify measures and hierarchies to create a cube schema and an Essbase model, as described in Creating an Oracle BI EE Cube Schema and Essbase Model.

  5. Click Next to create a cube schema from the Oracle BI EE elements, or click Finish.

    View the new metadata elements—dimension elements and hierarchies—listed in the Metadata Navigator.

    If you created a minischema, view the new minischema in the minischema work area of the Essbase Studio Console.