Download PDF file

Previous versions
8 Conditinal Writeback using the Cell Edited Action mode it is possible to create conditional writeback
scenarios with Application Studio reports, now.
9 Report Variables It is possible to create variables for certain reports, now. This improves the
handling of variables in general. The report variables have the same functionality as global variables
and can be accessed by the function Reportvariables.<variable name>.text Global variables can
be accessed by the spreadsheet function Globalvariables.<variable name>.text, now.
10 Default Value for Variables It is possible now to set a default value for variables so that every user
who log on finds the variables prefilled. This works for report variables and for global variables. You
can enter the default value in the properties of a variable.
11 Persistency It is possible now, to determine whether changes to the value of a variable shall be
saved as permanently (persistent), or if the values shall be reset to the default value of the variable
(non-persistent). For report variables changes values are saved while leaving a report. For global
variables the changed values are saved when logging off.
12 Multiple Hyperblock Output With Application Studio 10 it is possible for the first time to define
several output cells for a hyperblock, without using formulas. So it is possible e.g. to output several
columns of a relational list within a hyperblock, without using any formulas. New output cells can
be added easily by drag and drop or in the Hyperblock Properties dialog.
13 New Report Wizard With Application Studio it is possible to create reports, using a very powerful
Report Wizard. The former simple Report Wizard has been replaced by a new Report Wizard that
uses the report templates. Templates for the Report Wizard can be created by any Report Designer,
normally an experienced power user. The Report Wizard uses the template reports and duplicates
them for different data sources.The usage of the new Report Wizard is distributed in three steps:
1 A power user creates a report that can be used as report template. In such a template report all
lists are variable lists. That means that the data connection parameters have to be set by variables.
E.g. in an OLAP list the parameters for alias, cube, dimension and hierarchy have to be set by
variables. When data filters or sorting are used, those parameters have to be set by variables,
too.
2 In a 2nd step the power user defines a wizard for the report template. For each variable that is
used in the report the power user can set which type of data the variable is used for (alias, cube,
dimension, text ...). The power user can enter localized help texts for each parameter of the
Report Wizard and define which style reports shall be available for the report template.
3 A report designer uses the Report Wizard to create a new report based on the report template
or to modify an existing report.
Please Note: The former onVision 5.2 report templates have been renamed to "Style Reports" to
distinguish them from the new report templates.
14 MEMBERGET The MEMBERGET function returns an element of a dimension which can be selected
by different parameters. The function returns the unique name and the caption of the element.
=MEMBERGET(Alias;Cube;Dimension;Parameter; optional parameter) These parameters can be
set to select an element: SELF CHILD NEXT PREV SIBLING
15 SETPROPERTYThe SETPROPERTY function writes several values as a table to a single variable,
by means of xml. This function can be used to save an unknown number of values to one variable.
It can be used e.g. to create reports that are database independent. In such reports one cannot
know how many dimensions are in the used cube. Then it is possible to save the selection of an
unknown number of dimensions to one single variable.
=SETPROPERTY(Variable;Rowname;Property;Value)
Infor Business Intelligence Release Notes | 219