Navigation: Flag Descriptions >

Data Island Expression

 

 

 

 

The expression "xxx" uses a Field from an island table. Improper use of island fields may lead to performance problems. The field(s) are: "yyy"

 

Guide

 

Examine the performance of any chart using a data island expression. If a data island field it used with other dimensions, a temporary table of all possible combinations must be generated during calculation. To avoid this temp table generation, consider one of the following alternatives.

 

For a single value island field, such as a currency selection, replace the field reference with a $() expression. The $() expression is calculated only one.

          - Sum(Sales) / $(=Only(CurrencyRate))

 

Another good option is to replace the field reference with a variable calculation.

- Create a variable:  Set vCurrencyRate = =Only(CurrencyRate);  // Note the extra "="

- Use the variable in the expression: Sum(Sales) / $(vCurrencyRate)
 

 

 

 

 

QSDA Pro version 2.6.8