Using TRACE Statements

This applies to: Managed Dashboards, Managed Reports

This article shows you how to use #TRACE statements in server-side DundasScript, such as the ones used in calculated element transforms. The output from #TRACE statements goes to the application logs which can help you to debug your scripts.

DundasScript is used in several areas of the application, including:

• Data connectors (Generic Web, OLAP)

• Tokens

• Formulas

• Transforms (e.g., Calculated Element)

• Bridge Parameters

TRACE Statements

You can insert a #TRACE statement as a line of script anywhere DundasScript is used:

Using #TRACE With a Calculated Element Transform

For this example, create a new data cube and drag the [Production].[Product] table from a data connector in Explore to the canvas.

Select the connection link between the two transforms, go to the toolbar, click Insert Common, and then click Calculated Element.

Double-click the Calculated Element transform to configure it. In the configuration dialog, scroll down and click the plus button under Calculated Elements to add a new calculated element (i.e., a new output column which will be defined using a script).

Enter the Name of the calculated element, set its Data Type to String, and then type in the following Expression (script).

This script creates a new output column by concatenating two existing string columns. It also outputs a #TRACE statement to the application logs in administration for each product that has a Silver color.

Note: Calculated element transform scripts run for each row of data that is previewed or processed, which can produce many log entries if not restricted by your script.

Select the Process Result transform on the canvas and then click Data Preview to see the output from the data cube.

You'll see some information about where the script was executed, the line number of the #TRACE statement in the script (helpful if you have multiple such statements), and lastly the actual output of the #TRACE statement itself. For example:

For more information, see:

• Application Logs

• Writing Data Scripts with DundasScript

• Data Cubes

• Adding Formulas

• Using a Bridge Parameter

• Calculated Element