Selecting Hierarchies in the Introspection Wizard

  To select hierarchies to add as metadata elements during introspection:

1. In Select Hierarchies, select the hierarchies you want to use from the Hierarchies list.

   Hierarchies presents the hierarchies discovered by Essbase Studio after examining the data source. All hierarchies are selected by default. You can do any of the following:

   • Accept all the hierarchies discovered.

   • Select the hierarchies that you do not want to add as metadata elements and click the Delete selected item button.

   • Select a hierarchy within a multichain hierarchy and click the Delete selected item button.

   • Select individual members in a hierarchy and click the Delete selected item button.

   • Build a hierarchy by selecting the Create new hierarchy button. Then, follow these steps:

     1. In the Create Hierarchy dialog box, enter a Name for the hierarchy and an optional Description.

     2. Optional: If this is a measures hierarchy, select the Create as measures hierarchy check box.

     3. Click OK to return to the Select hierarchies page of the Introspection Wizard.

     4. Select the new hierarchy in the Hierarchies list, then, in the Available Tables and Columns list, navigate to the first column to add to the hierarchy, select it, and click the Add column as child button.

        The column you added is now a member in the hierarchy

        Note:

        The first column you add to the hierarchy must be added as a child.

     5. Add other columns to the hierarchy, using either the Add column as child or Add column as sibling button.

        Note:

        Be sure to first select either the hierarchy name or the correct member in the hierarchy before selecting columns to add as child or sibling members.

   • Build a hierarchy by selecting a table in the Available Tables and Columns and clicking the Add hierarchy for table button. Then, follow these steps:

     1. Select the new hierarchy in the Hierarchies list.

        The format for the hierarchy name is: tablenameHierarchy.

     2. Navigate in the Available Tables and Columns list to the first column to add to the hierarchy, select it, and click the Add column as child button.

     3. Add other columns to the hierarchy, using either the Add column as child or Add column as sibling button.

        Note:

        Be sure to first select either the hierarchy name or the correct member in the hierarchy before selecting columns to add as child or sibling members.

2. Click Finish.

   If you created a minischema, you can review it in the Minischema work area.

   Also, review the metadata elements created by the introspection process. They are listed in the Metadata Navigator under the appropriate folder.