Adding tables

Before you can begin creating attributes, facts, and hierarchies for your project, you must add tables to your project.

Along with making data available in your project, adding tables to your project can also trigger the creation of attributes and facts, and the mapping of columns to attributes and facts. For information on defining how attributes and facts are created and mapped when adding tables to your project, see Defining project creation and display options and Defining project creation and display options.

Once tables are selected from the data source and added to your project, they become schema objects known as logical tables in MicroStrategy. Logical tables are representations of the tables that are available in the data warehouse, and are discussed in detail in Logical Tables.

The procedure below provides steps to add tables to your project using Architect.

Prerequisites

You are creating or modifying a project using Architect. For instructions, see Creating and modifying projects.
The ability to add tables using Architect is enabled. For information on enabling and disabling the ability to add tables using Architect, see Defining project creation and display options.
If changes have been made to the tables within the tables’ data source, you must update the structure of the tables in MicroStrategy to ensure they can be added to a project successfully. For steps to update table structures, see Updating, modifying, and administering tables.

To add tables to a project using Architect

1 With a project open in Architect, select the Project Tables View.
2 From the Warehouse Tables pane, expand a data source.

If you have the MultiSource Option, you can add tables from multiple data sources into your project. For information on adding tables from multiple data sources into your project with the Warehouse Catalog or Architect, see Accessing multiple data sources in a project.

3 Right-click a table, and then select Add Table to Project. The table is added to the project and included in the Project Tables View of Architect.

To view a sample of the data within a table, right-click the table and select Show Sample Data.

4 If you have selected to automatically create attributes, attribute forms, and facts based on schema creation heuristics (see Defining project creation and display options and Defining project creation and display options), the Results Preview dialog box opens.

Attributes, attribute forms, and facts that can be created based on the columns of the table added to the project are displayed. Select the check box for each object to create in the table when the table is added to the project. If more than one attribute form is available for creation for an attribute, you must select the ID form. Any other attribute forms for that attribute are optional. Click OK to complete the processes of adding the table to the project and creating any selected attributes, attribute forms, and facts.

5 Once you have imported tables for your project, you can continue with other project design tasks, which include:
a Creating and modifying facts
b Creating and modifying attributes
c Defining attribute relationships
d Creating and modifying user hierarchies