Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

tracedasharea

  • To the right of the selected dasharea, using the Show bound data button:

tracebounddata

Upon selecting the trace button, a dialog displays containing six different 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.

Published:

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:

tracedasharea

  • To the right of the selected dasharea, using the Show bound data button:

tracebounddata

Upon selecting the trace button, a dialog displays containing six different 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.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk