Your database must be up and running in
order for you to complete these steps:
-
Log in to the User
Console.
-
Click Create
New, then choose Data Source from the
menu.
-
Click New Data Source.
The Data Source Wizard appears.
-
Enter a name that identifies your new data source in the Data Source
Name field.
The following characters are not allowed in
Data
Source
names:
%/:[]*|\t\r\n
-
Select Database Table(s) from the Source Type drop-down menu. Under Connection, click to choose a database
connection.
-
Click to select the Reporting Only radio button. Click Next.
-
Choose a schema from the Schema drop-down menu.
A list of
Available Tables appears.
-
Choose a table from Available Tables and click the Right
Arrow to move the table into the Selected Tables
field.
If you add a table you decide not to use, highlight the table and click the
Left Arrow to remove it from the list of Selected Tables.
To choose multiple tables, press the CTRL key down as you
make your selections.
-
Click Next.
The
Define Joins window appears. While you can
create a data source from a single table, the more common scenario is that you
will choose multiple tables which must then be joined.
-
Choose the fact table from the Left Table drop-down menu, then choose a table to join to it from the Right Table drop-down menu.
Click Create Join to define the inner join between each table.
-
Create join conditions for each entry in the Left Table
and Right Table drop-down menus.
The join relationship for each table is based on the field selected and is
displayed in the lower portion of the dialog box. To delete a join, select the
join and click Delete Join.
-
Click Finish. The Data Source Created window appears.
You can choose to
Keep default model or click
Customize model now to launch the
Data Source Model Editor and refine the model. Click
OK.
