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

Building Reports Using the Web Intelligence Java Report Panel 353
occur either when you use the Rank dialog box to create a ranking, or when you use the
Rank() function.
Example: Ranking on running average or previous values
If you attempt to rank a block on a column that contains the Previous() function or any
running aggregate function, the entire block returns #RANK.
#DATASYNC
#DATASYNC occurs when you place a dimension from a different data provider in a
block containing dimensions from another data provider, and the two data providers are
not synchronized through a merged dimension. #DATASYNC appears in all dimensions
in the block and #CONTEXT in the measures.
For more information on merged dimensions, see ”Merging dimensions from multiple data
providers” on page 73 on
page 351.
Example: Dimensions from different data providers in a block
If a report based on the Island Resorts Marketing universe contains data providers with the
objects (Year, Revenue) and (Quarter), a block containing Year, Quarter and Revenue
displays #DATASYNC in the Year and Quarter columns because the two data providers
are not synchronized through a merged dimension.
#CONTEXT
#CONTEXT is related to the #INCOMPATIBLE and #DATASYNC error messages, both
of which occur when a block contains a non-existent aggregation context. In the case of
#INCOMPATIBLE the aggregation context is non-existent because the dimensions are
incompatible; in the case of #DATASYNC the aggregation context is non-existent because
the dimensions are from multiple unsynchronized data providers.
Example: Non-existent aggregation context in a query
If a block based on the Island Resorts Marketing universe contains the Reservation
Year and Revenue objects, the #CONTEXT error message appears because it is not
possible to aggregate revenue by reservation year.
#SECURITY
#SECURITY occurs when you attempt to use a function for which you do not have security
rights.
Example: Using the DataProviderSQL() function
If a user who does not have the right to view data provider SQL places the
DataProviderSQL() function in a cell, the #SECURITY message appears in the cell.