Create Indicator Data

To create indicator data, complete the following steps in the SAS BI Dashboard designer.

Note: If any tabs are open in the workspace, close them.

In the workspace, click .
In the Create Indicator Data window, type the name to use for the indicator data component.
Click OK. A tab using the specified name appears in the workspace.

From the Data source list, click the type of data that you want to use for your indicator data.

Information map	Go to step 5.
SQL query	Go to step 6.
Stored process	Go to step 7.
Table	Go to step 8.

CAUTION:

The default maximum number of rows returned by any data source is 10,000.

If the source data contains more than 10,000 rows, an error message about making an adjustment appears. If possible, aggregate the data to reduce the number of rows to return.

If you selected Information map, complete the following steps.
1. Next to the Information map field, click Browse. The Open window appears.
2. Navigate to an information map, select it, and then click Open.
3. Move data columns and filters between the Available items list and the Selected items list by selecting one or more items and clicking the arrows between the lists.
  
  A filter is moved under the Filters node. By default, a data column is moved under the Column node.
  
  Note:
  
  To make available a filter that contains a user prompt, the prompt must have a default value specified in SAS Information Map Studio.
  
  If the information map is based on an OLAP cube, the Selected items list includes the nodes Row and Slicer. To use a data column in either of these roles, select Row or Slicer before moving the data column from the Available items list.
4. To move a data column between groups, click the name of a data column in the Selected items list, and then move it up or down by clicking one of the arrows that are next to the list.
  
  Note: The order of the columns in the Selected items list specifies the default sort order for the data that is displayed in an indicator.
5. Go to step 9.
If you selected SQL query, complete the following steps.
1. In the Query field, type the SQL query code to use.
2. Go to step 9.
If you selected Stored process, complete the following steps.
1. Next to the Stored process field, click Browse. The Open window appears.
2. Navigate to a stored process, select it, and then click Open.
3. From the Published data set name list, select a data set.
  
  Note: If a stored process does not create a data set, an error message appears when that stored process is selected.
4. (Optional) Click Always add SAS log to server log to have the SAS log added to the server log.
  
  Note: Selecting this option enables you to review the SAS log information later.
5. Go to step 9.
If you selected Table, complete the following steps.
1. From the Table tree, select a table. The data columns in the table appear in the Available columns table.
2. From the Available columns table, select the data columns to include in the indicator data by clicking the check box at the end of a row.
3. For each selected data column, select a method to summarize the data from the Summary column.
  
  Tip
  By default, all numeric columns are summarized unless you select (none). Summarization can produce incorrect results for the following values: date, time, and datetime. Be sure to select (none) for these values so they are not summarized.
4. For each selected data column, choose whether to group the data by clicking the check box in the Group By column.
5. To specify additional filters, type the filter (using SQL syntax) into the Filters field.
  
  Note: Do not type the key word where. This causes an error because where is automatically supplied.
Click Apply Query Changes. In the Preview Design area, the Data Mapping and Query Results tabs are updated with the data.
To view the data that is included in the indicator data, click the Query Results tab.
To associate a data point property with data columns in the data source, perform the following steps in the Data Mapping tab for each data point property.

Note: For more information, see Data Column Display Attributes.
1. Next to the Column Name column, click the check box next to each data point property that you want to include in the indicator.
2. In the Label Override field, type the label to use for the data point property instead of the label from the Column Name column.
3. In the Value field, select the name of the column that contains the formatted value of the original value.
  
  Note: KPI indicator subtypes that are gauges display this value at the bottom of each gauge. The value also appears in a tooltip for the gauge.
4. From the Hyperlink list, select a data column in the data source that contains the hyperlink for the data point property.
Click FileSave.
In the Save As window, type a name and choose a location, such as ProductsBI Dashboard 4.4DashboardConfigs.
Click Save.
In the Library section of the Objects pane, navigate to the location that you selected in the Save As window. The indicator data file is located in this directory.

Note: The filename uses the name that you specified. The file extension is .imx.
Close the indicator data tab in the workspace.