Reference Guide

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.