During introspection, you are presented with fact table candidates, from which you make a selection.
To select a fact table:
In Select Fact Table(s), select the objects you want to use as fact tables, and click Next.
The Fact Table(s) list contains tables which, after examining the data source, Essbase Studio proposes as possible fact tables.
You can accept one or more of these selections or, using the arrow keys, remove them and choose one or more tables from Available Tables to use as fact tables.
Note:
The Available Tables list contains all the remaining tables, views, alias tables, and synonyms that were selected when the data source was created.
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 area, such as:
perf*
Filters apply to all tables, views, aliases, or synonyms you have included in the selected data source.
When you have made your selections, click Next to view the Select Dimension Table(s) page of the Introspection Wizard.