Inserting a Query Calculation

Insert a query calculation into your report to add a new row or column with values that are based on a calculation. For example, you create a query calculation named Euros that converts dollars to euros by multiplying an existing dollar measure by a conversion rate. Euros can then be displayed to end users in a separate row or column.

Quality of Service Indicators

Not all data sources support functions in the same way. The data modeler can set a quality of service indicator on functions to give a visual clue about the behavior of the functions. Report authors can use the quality of service indicators to determine which functions to use in a report. The quality of service indicators are as follows:

not available (X)
This function is not available for any data source in the package.
limited availability (!!)
The function is not available for some data sources in the package.
limited support (!)
The function is available for all data sources in the package but is not naturally supported for that data source, which can result in poor performance and unexpected results.
unconstrained (check mark)
The function is available for all data sources.

Using Quotation Marks in Literal Strings

When inserting literal strings in an expression, you must enclose the string in single quotation marks. If the string contains a quotation mark, it must be modified. For example, if you want to insert the string ab'c, you must type 'ab''c'.