Bookshelf Home | Contents | Index | PDF     

Siebel Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Tables >

Adding or Editing Logical Table Sources

You can add a new logical table source, edit or delete an existing table source, create or change mappings to the table source, and define when to use logical tables sources and how content is aggregated. Additionally, you can copy aggregation content to the Windows clipboard or from another logical table source, and check the aggregation content of logical fact table sources.

You would add new logical table sources when more than one physical table could be the source of information. For example, many tables could hold information for revenue. You might have three different business units (each with its own order system) where you get revenue information. In another example, you might periodically summarize revenue from an orders system or a financial system and use this table for high-level reporting.

To add or edit a new logical table source

  1. In the Business Model and Mapping layer, double-click a table.
  2. In the Logical Table dialog box, select the Sources tab.
  3. In the Sources tab, perform one of the following steps:
    • To add a table source, click Add.
    • To edit an existing table source, select a source and click Edit.
  4. In the Logical Table Source dialog box, in the General tab, complete the fields.
  5. Click the Column Mapping tab and select one of the following check boxes or click New column:
    • Show mapped columns. Shows current mapping for the table.
    • Show unmapped columns. Shows columns available for mapping.
  6. Set up mappings for the table source.
  7. Click the Content tab and complete the fields using Table 17 as a guide.
  8. Click OK.
Table 17.  Content Tab Fields for Logical Table Source
Field
Description

Aggregation content, group by

How the content is aggregated.

Show mapped/Show unmapped

Select check box to see a list of mapped or unmapped columns. Clicking the Dimension header toggles the sort between ascending and descending order.

More (button)

When you click More, the following options appear:

  • Copy. (Available only for fact tables) Copies aggregation content to the Windows clipboard. You can paste the Dimension.Level info into a text editor and use it for searching or for adding to documentation.
  • Copy from. (Available for fact tables and dimension tables) Copies aggregation content from another logical table source in the same business model. You need to specify the source from which to copy the aggregation content. (Multiple business models appear but only the logical table sources from the current business model are selectable.)
  • Get Levels. (Available only for fact tables) Changes aggregation content. If joins do not exist between fact table sources and dimension table sources (for example, if the same physical table is in both sources), the aggregation content determined by the administration tool will not include the aggregation content of this dimension.
  • Check Levels. (Available only for fact tables) check the aggregation content of logical fact table sources (not dimension table sources). The information returned depends on the existence of dimensions and hierarchies with levels and level keys, and physical joins between tables in dimension table sources and the tables in the fact table source. (If the same tables exist in the fact and dimension sources and there are no physical joins between tables in the sources, the Check Levels feature will not include the aggregation content of this dimension.)

Fragmentation content

A description of the contents of a data source in business model terms. Data is fragmented when information at the same level of aggregation is split into multiple tables depending on the values of the data. A common situation would be to have data fragmented by time period.

This source should be combined with other sources at this level (check box)

Check this box when data sources at the same level of aggregation do not contain overlapping information. In this situation, all sources must be combined to get a complete picture of information at this level of aggregation.

Select distinct values

Not currently used.
    
Siebel Analytics Server Administration Guide