Trace
Trace can be used as a tool for the Dashboard Designer when designing the dasharea or for troubleshooting purposes.
Trace can be access from two different locations:
In the Data Bindings section, when a particular dasharea is selected:
To the right of the selected dasharea, by selecting the Show bound data button:
Upon selecting the trace button, a dialog displays containing six different tabs:
Below is a list of the Dataview tracing tabs:
Tab | Description |
---|---|
Dataview Preview | Preview of the data in the dataview. This feature is useful when designing a chart, to view the actual data in each dataview column. The preview returns the top 100 results. |
Dasharea Data | The data returned by the cached SQL and shown in the chart . |
Selection Pane Values | Values selected in the selection pane, if the dashboard is connected to one. |
Trace | The dataview SQL query. |
Cached SQL | The actual SQL query that is created by Bizview and combines the dataview SQL, aggregation types of the measure columns, selections in selection pane, any filters added, and/or field sortings. This is the SQL query that populates the dasharea with the data. The data returned by the cached SQL query can be viewed in the Dasharea data tab. |
Error | Displays any error messages. |