Objective
After completing this lesson, you will be able to Define @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.
The following is the list of functions supported in the Information Design Tool:
| @Function | Description | |
| @Aggregate _Aware | Directs an object to query, in succession. The tables are listed as parameters in the @AGGREGATE_AWARE function. | |
| @DerivedTable | References 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. | |
| @Execute | References a list of values. | |
| @Prompt | Prompts 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. | |
| @Select | Enables you to reference the SELECT statement of another object. | |
| @Variable | References the values assigned to Business Objects system variables, report variables, language (locale) variables, or Operating System variables.. | |
| @Where | Enables you to reference the WHERE clause of another object. | |
The following table shows which @functions are supported in the different query expressions:
| @Function | Joins | Calculated Columns | Derived Tables | Objects |
| @Derived Table | Not allowed | Not allowed | Allowed | Not allowed |
| @Execute | Allowed | Allowed | Not allowed | Allowed |
| @Prompt | Allowed | Allowed. | Allowed | Allowed |
| @Select | Not allowed | Not allowed | Not allowed | Allowed |
| @Variable | Allowed | Allowed | Allowed | Allowed |
| @Where | Not allowed | Not allowed | Not allowed | Allowed (SQL only) |
Log in to track your progress & complete quizzes