The Data Source Navigator, displayed by default in the right pane of the Essbase Studio Console lists the physical data sources to which you have created connections. This structure is often referred to as the physical tree. You can launch the Connection Wizard from here, where you create data source connections. For each data source connection, the associated minischemas are also displayed. Minischemas are graphical representations of the tables you select from one or more data sources connections. You can create minischemas when creating data source connections, or you can create them later.
Other tasks that you can perform on data sources are:
View sample data from a selected table in a data source
Show the “friendly names” of tables in a Microsoft SQL Server data source
Refresh the data sources list
Introspection, an analysis of the data source connection to identify possible hierarchies
Incrementally update an existing data source
Create user-defined tables
Create, edit, and manage minischemas.
Minischemas are graphical representations of the data sources to which you have created connections. You can create minischemas when creating data source connections, or you can create them later. Minischemas may contain a subset of the tables in a data source connection or all the tables. Alternatively, minischemas can contain tables from multiple data sources.
For more information on data source connections and minischemas, see: