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

Troubleshooting formulas352
You have a report showing Country, Resort and Revenue and you add a cell to the
report containing the formula
[Revenue] ForEach ([Country]). This cell returns #MULTIVALUE
because Country has two values in the report: ‘US’ and ‘France’.
One cell cannot display the revenues for both the US and France. Placed outside the
table, a cell containing revenue can only aggregate the revenues in the table in some way
(for example by summing or averaging them).
Note: If the report is broken into sections on Country, the formula is correct when placed
in a section because there is only one value of Country per section. Outside a section,
however, the formula still returns #MULTIVALUE.
#OVERFLOW
#OVERFLOW occurs when a calculation returns a value that is too large for Web
Intelligence to handle. This value, in exponential form, is 1.7E308 (1.7 followed by 307
zeros).
#SYNTAX
#SYNTAX error when a formula references an object that no longer exists in the report.
Example: Referencing a non-existent object
You have a report that originally showed Year, Quarter and Sales revenue, with an
additional column showing difference between the revenue and the average yearly
revenue. This figure is given by the variable Difference from Yearly Average.
If the Difference from Yearly Average variable is deleted from the report, the column
containing it returns #SYNTAX.
#INCOMPATIBLE
#INCOMPATIBLE occurs when a block contains incompatible objects. For an
explanation of incompatible objects, see ”About Incompatible objects in data providers”
on page 52.
Example: Incompatible objects in a query
If a block based on the Island Resorts Marketing universe contains the Year and
Reservation Year dimensions, the columns containing these dimensions show
#INCOMPATIBLE because these objects are incompatible.
#RANK
#RANK occurs when you try to rank data based on an object that depends on the order of
values. (Objects that use the
Previous() function or any running aggregate function depend
on the order of values.) Ranking causes these objects to recalculate their values, which
then changes the ranking, resulting in a circular dependency. Such a dependency can