Data Params
Data Params set data parameters and bring data into Dashareas. Data Params consist of Global parameters (overall parameters for all series) and Parameters for each individual series (one tab for each series will be created in the Data Params tab)
This topic contains the following sections:
Global Parameters
Below is a list of Global Parameter attributes and functions:
Attribute | Function |
---|---|
Top N | If a top list is created, enter how many records the top list should return (i.e. 5, 10, etc). |
OrderBy | Sets the order in which the column data should be ordered by. Options include: XValue, YValue, ZValue, or Tag. They can be Ascending or Descending. |
Do not inherit Where | Enables or disables the inheritance of Where filters from the parent dasharea to the linked dasharea. If selected, no selection criteria from the parent dasharea will be sent in to the linked dasharea when drilling down from one chart to another. |
Parameters for Each Series
Set the specific parameters for each individual Series. See image below:
Below is a list of Data Series properties:
Property | Description |
---|---|
Data Source | Select which data source should fetch data. |
Data Table | Select which table or view in the defined data source should fetch data. |
X Column | Select which column in the defined table or view should return values for the X-Axis. |
Y Column | Select which column in the defined table or view should return values for the Y-Axis. |
Y Scale | Enter a scale factor that the data values should be multiplied by. |
Tag Column | Select which column in the defined table or view should return values as tag-values. A tag column can be any additional column that you want to add to the dasharea dataset in order to use to return in tooltips, etc. For example, the x-column returns period values (201301), however, in the datapoint tooltip you also want to show the month in text. If you have a column in the defined table/view that returns the month values in text, then this column can be selected in the tag column field and thereafter, #tag can be used in tooltips to return these additional values. |
Z Column | Applies only to Bubble charts. Select which column in the defined table or view should return values for the Z-Axis. |
Z Scale | Enter a scale factor that the data values should be divided or multiplied by. |
Is Primary | Mandatory function. When using more than one series, one of the series must be defined as primary. |
Note: Test the area by selecting the Test icon. This checks that the data and SQL queries work as they should. You can use this feature to test entire dashboards or single dashareas. If the dasharea is dependent on a Selection Pane, you must first select the Selection Pane, and thereafter, you can perform your test.
Data Provider and Source
Add and manage Data Providers and Sources under Data Services.
The client must be able to read table schemes and meta data (e.g. db_owner or sa). This allows the tables and views to display in the Data Table (Data Params) drop-down list.
Note: If the client/user lacks these elevated rights, it's possible to manually enter the data table.