HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Using Web Intelligence functions230
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 several categories of functions:
You can see a full list of the functions available in Web Intelligence, see ”Functions
available in Web Intelligence” on page 233
Function examples and descriptions
This section shows how to use some of the functions available with Web Intelligence to
answer typical business questions. Later in this section, you will find a detailed description
of each function and gives an example of the information each function enables you to
include in reports.
Example: Calculating a percentage using the Percentage function
Web Intelligence has the Percentage function for calculating percentages. This function
calculates the percentage of a number in relation to its surrounding context. For example,
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