Application Studio

Multi-value parameters

Parameters that reference multiple parameters are now supported in the SQL queries that define relational lists and in DBEXECUTEFIXED formulas. Multiple values referenced by a parameter must be separated with the pipe (|) character. Multi-value parameters are referenced by @@. Single value parameters are referenced with a single @.

Page setup with current user name

You can add the user name of the current user to the header or footer of a report using the Page Setup dialog box. A report's page setup is used when exporting the report to PDF or when printing.

FORMATSTRING function

Use FORMATSTRING to apply the number formatting of a data source to a cell value. For example:

= FORMATSTRING(CELLGET(alias, cube,...)/scalingvariable, CELLGET() )

Typically, to achieve this, you apply the ~ number format. But, if the value returned by, for example, a CELLGET function is modified by a mathematical operation, then FORMATSTRING is required.