Selecting schema display options - SAP BO

You can customize the shape or appearance of the tables, columns, joins, and cardinalities in the "Structure" pane.

You have the following graphical options for the display of components in the structure pane:

Selecting schema display optionsSelecting schema display options

Setting graphic options for the Structure pane display

You can set graphic options for the components of the "Structure" pane as follows:

  1. Select Tools > Options.
    The "Options" dialog box appears.
  2. Click the Graphics tab.
    The "Graphics" page appears. It lists graphic options for components in the
    "Structure" pane.
  3. Select or type graphic display options.
  4. Click OK.

Examples of graphical options

The following are some examples of the possible graphical representations of components in the structure pane using the graphical options available in the "Options" dialog box (Tools > Options > Graphics.

Aliased name

When selected an aliased table in the "Structure" pane is displayed both with its name and the name of the table from which it is derived, in parentheses.

Show Row Count and Show Format

When Show Row Count is selected the number of rows in each table appears at the bottom of each table symbol. You need to select View > Number of rows in Table to refresh row numbers for all tables before the row count is displayed.

When Show Format is selected, a letter representing the column type appears beside the column name. The column type can be:

  • C for character
  • D for date
  • N for number
  • T for long text
  • L for blob (binary large object).

In the "Structure" pane, the numbers appear below the lower left corner of the tables, the data types are shown next to the column names.

Viewing table and column values

You can view the data values of a particular table or column. The default number of rows that you can view for any table is 100. You can change this value to return more or less rows depending on your needs.

Viewing the values of a table

To view the values in a table:

  1. Click the table in the "Structure" pane.
  2. Select View > Table Values.
    A content dialog box for the table appears listing the values for each column in the table.
  3. Viewing the values of a table

  4. Select the Distinct Values check box if you want to show only distinct values.
  5. Click Close.

Viewing the values of a column

When viewing column values you can enlarge the view of the columns by selecting View > Zoom In. This makes it easier to select a column. You can view the values for an individual column as follows:

  1. Place the pointer over a table column in the "Structure" pane.The pointer is transformed into a hand symbol.
  2. Right-click the column and select View Column Values from the contextual menu.A content dialog box for the column appears listing the column values.
  3. Viewing the values of a column

  4. Select the Distinct Values check box if you want to show only distinct values.
  5. Click Close.

Modifying the default value for number of returned rows

You can modify the default value for the number of rows returned when you view table or column values. This can be useful if you only want to view a small sample of the values in a table, so you can restrict the returned values to a smaller number.

To modify the number of rows fetched for a table:

  1. Select Tools > Options.
    The "Options" dialog box appears.
  2. Click the Database tab.
    The "Database" page appears.
  3. Type or select a number using the up and down arrows from the Table and Columnvalues list box.
  4. The "Database" page below has 20 rows specified to be returned when values areviewed for a table or column.

    Modifying the default value for number of returned rows

  5. Click OK.

Viewing the number of rows in database tables

You can display the number of rows in each table. You do this in two stages:

  • Activate the graphic option Show Row Count (Tools > Options > Graphics),
  • Refresh the row count for all tables by selecting View > Number of Rows in Table.

You can display the number of rows in each table in the database, or you can set a fixed number of rows for a selected table to optimize query performance. This allows you to control the order of tables in a FROM clause, which is based on table weight.

Displaying number of rows in tables

To display the number of rows in each table:

  1. Select Tools > Options.
    The "Options" dialog box appears.
  2. Click the Graphics tab.
    The "Graphics" page appears.
  3. Select the Show Row Count check box.
  4. Click OK.
  5. Select one or more tables.
    Or
    Click anywhere in the "Structure" pane and select Edit > Select All to select all the tables in the structure pane.
  6. Select View > Number of rows in Table.
    The "Table Row Count" box appears.
  7. Displaying number of rows in tables

    The options in this dialog box are described below:

    dialog box

  8. Select the Refresh row count for all tables radio button.
  9. Click OK.

The row count for each selected table appears under the bottom left corner of each table symbol in the "Structure" pane.

Modifying the row count of a table

You can modify the row count of tables. Two reasons for doing this are as follows:

Modifying the row count of a table

To modify row count of one or more tables:

  1. Select Tools > Options.
    The "Options" dialog box appears
  2. Click the Graphics tab.
    The "Graphics" page appears.
  3. Select the Show Row Count check box.
  4. Click OK.
  5. Select one or more tables.
    Or
    Click anywhere in the "Structure" pane and select Edit > Select All to select all the tables in the structure pane.
  6. Select View > Number of rows in table.
    The "Table Row Count" box appears.
  7. Select the Modify manually tables row count radio button.
  8. Type the number of rows that you want to display for the table
  9. rowcountintable.

  10. Click OK.

The row count for each selected table appears under the bottom left corner of each table symbol in the "Structure" pane.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BO Topics