2. Source database table or file selection.

This screen is used to choose tables or files from the database where the cube's source data is.

The options in this screen are:

• Add : Use this button to add a file or a table to the list. When you press this button the Add tables dialog appears.
• Remove: Select a table from the list and press this button to take out the selected table from the list and the cube definition. You can't remove tables whose columns or fields are used.

In the selected tables list, the following fields are shown:

• Type : Table type. This type is determined by the database and normaly is either TABLE (physical table) or VIEW (virtual table).
• Owner : Table owner, used in relational database.
• Name : Table name in the database..
• Alias : Usually is the same name as the table name, the alias is a name that you give to the table to reference it. It is useful when you use one table more than once. The alias name must be a valid identifier: it must start with a letter and is followed by letters, numbers or the '_' character.

If you receive an error when retrieving table and column information from the database, please click here.

If you have choose at least one table, you can press the Next button to proceed to the next section of this assistant: 3. Select fields from database .

The Back button will take you to section 1. Connection to source database.