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 Create OBIEE dimensions, in the Available OBI dimensions list, select which dimensions to add to the folder for this data source in the Metadata Navigator.

    • For all available OBI dimensions in the data source: 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.

    • For selected OBI dimensions: To create metadata elements, including hierarchies and their related dimension elements, select the check box next to the dimension names that you want to add.

  2. 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.

  3. 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.