Product specifications

DescriptionFile section

Functions available to universe design tool and information design tool, for

example Average, Sum, Variance. Functions are also available to Desktop

Intelligence, which is not part of this release.

Help text that appears when functions in this section are selected in universe

designer tool and information design tool is listed in the file <driver><lan

guage>.prm, for example, oracleen.prm. This file is found in the same

directory as the <driver>.prm file. You can open it to view descriptions of

all the functions available in the <driver>.prm file.

The Functions section has the following child elements:

• Group: whether the usage of this function in a query generates a group

by clause.

• True sets that the query generates a group by clause.

• False sets that the query does not generate a group by clause.

• ID: this is the name that appears in the "User Objects" function list in

Desktop Intelligence. Deprecated in this release.

• InMacro: if this value is True, then the function is listed in the "User

Objects" function list in Desktop Intelligence. Deprecated in this release.

• Type: function data type.

• Arguments: arguments accepted by the function. A function can have a

maximum of only four arguments, and any additional arguments are not

taken into account.

• SQL: the SQL syntax for the function.

Functions