Data Source Wizard

x

CSV

x

x

1. Log in to the User Console.

2. Click Create New, then choose Data Source from the menu.

3. Click New Data Source. The Data Source Wizard appears.

4. 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

1. Select CSV File from the Source Type drop-down menu.

2. Click Import to browse for your CSV file. Double-click to select the CSV file you want to upload.

3. Choose your delimiter and enclosure types.If you want to use the first row as data, disable the First row is header check box.

4. The File Preview window displays the first few lines of your CSV file based on the selections you made for the delimiter, enclosure, and header. Once the columns align correctly in the preview, the delimiter and enclosure have been set correctly.If you want to use the first row of your CSV file as headings for columns in the file, leave First row is header check box selected.

5. Click Next.The Staging Settings screen displays a list of columns from your CSV source file. All columns are enabled.

6. Choose the columns that you want to use in your data source, either individually or by clicking Select All.You can deselect all columns by clicking Deselect All.

7. Change the Name and Type values, if applicable.

   1. Choose the options that you want to use from the drop-down menu for dates and numeric values.

   2. You can enter a value manually in the Source Format text box.

   Note: Drop-down lists are not enabled for certain data types such as the String data type. Boolean values are rendered as true or false.

8. Click Show File Contents to look at a sample of the data in your source file. Click Close to return to the Staging Settings screen.

9. Continue to work with your CSV data settings or click Finish.The Data Source Created window appears.

10. 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.

SQL Queries

Database Table

When you create a Database Table data source, you are presented with two options: Reporting Only or Reporting and Analysis. The choice you make depends on the structure of the database tables you are accessing and the User Console tools being used.

Before you begin working with Database Table data sources, there are a few key terms that you should know.

Fact Table: Records measurements or metrics for a specific event, and usually consists of numbers.

Star schema: Has one or more fact tables that reference any number of dimension tables. Star schemas are good for simpler queries.

Snowflake schema: Has centralized fact tables that are connected to multiple dimensions. Snowflake schemas are good for more complex queries.

x

x

x