List of Substitution Parameters

You can use the following substitution parameters in a query:

Tag Description
[SelectCriteria] Expands the summary levels into the select statement e.g. if year was selected this would expand to be select Period_Year.
[SelectCriteria:Object] As above this tag expands the summary levels but in this case if will only do it for the specified object eg [SelectCriteria:Period] will only expand the Period object.
[WhereCriteria] Expands the where clauses into the sql statement eg if year 2005 was selected this would expand to be where Period_Year = ‘2005’.
[WhereCriteria:Object] Expands the where clause for the specified object.
[GroupCriteria] Expands the summary levels into the group criteria.
[GroupCriteria:Object] Expands the summary levels into the group criteria for the specified object.
[Object:Attribute:Values] Expands the values for the specified Object and Attribute for example if the user had selected Period Year 2005 this tag would expand to ‘2005’.
[ObjectAttribute] Expands to the first attribute of the first object in the selection criteria this tag is primarily used for parameter commands.
[System:Application] Expands to the Application
[System:Site] Expands to the Site

[Security:Username]

or [System:Username]

Expands to the username of the token used for the current query.
[IncludeSQL:filename] Include content of the specified file name. File should be located under SQL folder
[ExecuteSQL:filename] Include content of the specified file name in form of execution statement and insure it is properly quoted. Implementation depends from the SQL server. For Microsoft SQL server it will be replaced to:

execute (‘double ‘’quoted’’ statement to run’)