The Metadata Navigator, displayed by default in the left pane of the Essbase Studio Console, contains the following:
Metadata elements derived from the physical data sources when you create a data source connection.
Each time you create a new data source connection, you can create metadata elements from the physical elements in the data source to which you have connected. These metadata elements are displayed by default in a folder structure that mimics the tables and columns in the data source.
The Metadata Navigator displays metadata elements from multiple data source connections as well as objects from any type of supported data source. For example, your business may require access to data from sources as varied as relational, text files, Oracle BI EE, and Oracle Hyperion EPM Architect, Fusion Edition. After you create the connections to these sources, the metadata elements derived from each data source are displayed in a tree structure in the Metadata Navigator. Default folders are created to contain the metadata elements for each data source and, optionally, you can create folders during the data source creation process to further organize the metadata elements in the tree.
Metadata elements that you create from the derived metadata artifacts in the Metadata Navigator.
From the derived metadata artifacts you can further create metadata elements such as:
Folders
Dimension elements
Derived text measures
Standard hierarchies
Measure hierarchies
Calendar hierarchies
Text lists
Cube schemas
Essbase models
Drill-through reports
These metadata elements are used to create cube schemas and models that work with Essbase. Essbase models are used to create and deploy Essbase cubes.