RunQuery Script Examples

This page contains script examples for the RunScript script command.

This example runs an expression analysis.

(SELECT 'TargetTable', '#MyTempTable') UNION ALL
(SELECT 'Configuration', '
{
	"Dimensions": [
		{
			"Name": "dimension0",
			"Expression": "Attribute(\"Company Code\")"
		}
	],
	"Values": [
		{
			"Name": "measure0",
			"Expression": "Count(_)",
			"AggregationExpression": "Sum(_)"
		}
	],
	"Ordering": [
		{
			"Name": "measure0",
			"Direction": "Descending"
		}
	],
	"AggregateOthers": true,
	"MaximumRowCount": 20,
	"EnableResultCaching": true,
	"ModelId": 140559
}
')
--#RunQuery