Performing Introspection on a Data Source Connection

Introspection is a method of inspecting a physical data source for metadata elements. When you perform introspection, structural information in the data source is inspected to detect fact tables, dimension tables, hierarchies, aliases, and attributes. The metadata elements derived from introspection are then used to create cube schemas and, optionally, Essbase models.

Introspection can be performed during the data source connection creation process. Introspection can also be performed on an existing data source connection.

  To launch introspection on an existing data source connection:

  1. From the Source Navigator, select the Data Sources tab.

  2. Under Data Sources in the physical tree, right-click the data source on which you want to perform introspection and select Introspect.

For instructions on performing introspection, see Introspection.