If you chose to create a cube schema and Essbase model in step 4 of Creating Oracle BI EE Dimensions, then, in this page of the wizard, you use the Oracle BI EE dimension elements and hierarchies you just created to set up a cube schema and automatically create an Essbase model.
To set up a cube schema and Essbase model using Oracle BI EE fact tables and dimensions:
In the Create OBIEE cube schema page of the wizard, from the Available Fact Tables list, expand the Oracle BI EE fact tables, select the columns to move to the Measures list, and click the right arrow.
You cannot make selections at the fact table level. However, you may select one or more columns from the fact tables listed.
Note: | You can also use drag-and-drop to move dimensions between the Available Fact Tables list and the Measures list. |
In the Available Dimension Elements list, select the Oracle BI EE dimensions to move to the Hierarchies list, and click the right arrow.
Note: | You can also use drag-and-drop to move dimensions between the Available Dimension Elements list and the Hierarchies list. |
View the new metadata elements—dimension elements, hierarchies, cube schema, and Essbase model—listed in the Metadata Navigator, either in the default folder for the metadata elements or in the folder you specified in step 3 of Creating Oracle BI EE Dimensions.
You may work with these elements as you would elements created from any other relational source.