Setting Schema Preferences

Set schema preferences to control the display of minischemas in Essbase Studio Console.

  To set schema preferences:

  1. Select Edit, then Preferences.

  2. To control the display of data source objects in the table objects of a minischema, select or clear the following options in the Relational table display options

    • To display symbols representing columns types to the left of the column name, select Column type indicator.

    • To display a key symbol to the right of the primary key column name select Primary Key.

    • To display a symbol representing columns that have foreign key relationships, select Foreign Key.

  3. To control the way join lines are displayed between joined tables, select an option from the Join Connector group:

    • Diagonal—Enables join lines to be drawn diagonally between tables, where appropriate.

    • Rectangle—Enables join lines to be drawn only at right or left angles between tables, where appropriate.

  4. To control the display of the ends of join lines between tables, select an option from the Join Ends group:

    • Arrow—Displays an arrow at the end point of the join.

    • Crow's Feet—Displays a three-pronged “crow's feet” pattern at the end point of the join.

  5. Click Apply to apply your selections, then click OK.

    Note:

    To return to the default preference settings, click Restore Defaults.