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