HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Web Intelligence functions338
This description of a function’s inputs and outputs it known as its prototype. You see a brief
description of a function prototype when you select the function in the Formula Editor. For
example, if you select the Abs function, you see the following display:
You can get a much more detailed description of the function, including its prototype and
examples of its use, by clicking the More on this function after you have selected the
function in the Variable Editor. When you do this the online help opens to the page that
describes the function you have selected.
Using functions
Often you need to build additional calculations or objects into a report beyond the report’s
base objects or calculations. In some cases existing report objects are sufficient to create
these additional objects or calculations. For example, if you have Revenue and
Number of Sales objects you can create the formula
[Revenue]/[Number of Sales] to show
the revenue per sale.
More often you need to use functions to provide the additional calculations and objects
you need. Web Intelligence has seven categories of functions:
Category Description
All All the functions for all the categories listed
below in this table.
Aggregate Aggregates data (for example by summing
or averaging a set of values)
Character Manipulates character strings
Date and Time Returns date or time data
Document Returns data about a document
Data Provider Returns data about a document’s data
provider
Logical Returns TRUE or FALSE.
Numeric Returns numeric data
Misc Functions that do not fit into the above
categories