Using @ Functions in SQL

Objectives

After completing this lesson, you will be able to:

  • Define @Functions

@ Functions

@Functions are special Information Design Tool functions that provide more flexible methods for specifying the query script for an object. The Functions box in the SQL and MDX Expression Editor lists the @functions for the expression you are defining.

Information Design Tool Supported @Functions

The following is the list of functions supported in the Information Design Tool:

Information Design Tool Supported @functions

@FunctionDescription
@Aggregate _AwareDirects an object to query, in succession. The tables are listed as parameters in the @AGGREGATE_AWARE function.
@DerivedTableReferences a derived table. A nested derived table (also known as a derived table on a derived table) is a table that is derived from at least one existing derived table.
@ExecuteReferences a list of values.
@PromptPrompts the user to enter a value each time the object using the @PROMPT function is included in a query. Note: The existing syntax of the @PROMPT function is supported in the information design tool. You can also define a named parameter for the prompt and reference the parameter in the query script using the @PROMPT function.
@SelectEnables you to reference the SELECT statement of another object.
@VariableReferences the values assigned to Business Objects system variables, report variables, language (locale) variables, or Operating System variables..
@WhereEnables you to reference the WHERE clause of another object.

Query Expression Supported @Functions

The following table shows which @functions are supported in the different query expressions:

The @functions Supported in Query Expressions

@FunctionJoinsCalculated ColumnsDerived TablesObjects
@Derived TableNot allowedNot allowedAllowedNot allowed
@ExecuteAllowedAllowedNot allowedAllowed
@PromptAllowedAllowed.AllowedAllowed
@SelectNot allowedNot allowedNot allowedAllowed
@VariableAllowedAllowedAllowedAllowed
@WhereNot allowedNot allowedNot allowedAllowed (SQL only)

Log in to track your progress & complete quizzes