During introspection, you are presented with dimension table candidates from which you make selections.
To select dimension tables:
In Select Dimension Table(s), select the objects that you want to designate as dimension tables.
The Selected Dimension Table(s) list may already contain objects which, after examining the data source, Essbase Studio proposes as possible dimension tables. You can accept these choices or, using the arrow keys, remove them and choose objects from Available Objects to designate as dimension tables.
Optional: Enter a Filter to limit the tables displayed in Available tables, and click Apply.
For example, if database tables are prefixed for a certain business area, such as “perf” for Performance, enter a filter to return only those tables that pertain to that area, such as:
perf*
Filters apply to all tables, views, aliases, or synonyms you have included in the selected data source.
Click Next to view the Select Hierarchies page of the wizard.