Bookshelf Home | Contents | Index | Search | 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
- In the Business Model and Mapping layer, double-click a table.
- In the Logical Table dialog box, select the Sources tab.
- In the Sources tab, perform one of the following steps:
- In the Logical Table Source dialog box, in the General tab, complete the fields.
- Click the Column Mapping tab and select one of the following check boxes or click New column:
- Set up mappings for the table source.
- Click the Content tab and complete the fields using Table 14 as a guide.
- Click OK.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 11 March 2004 |