Understanding dynamic and permanent columns
BIRT Analytics uses the term dynamic column to describe a column that contains only a formula, but no data values. A formula consists of one or more expressions and operators. Using BIRT Analytics Loader, you can edit the formula that defines a dynamic column. To edit such a formula, you change any of the expressions or operators in the formula. You create a dynamic column using instructions known as transformation instructions. The dynamic columns appear as editable columns in BIRT Analytics.
For a dynamic column, the column property Derived displays the formula name of the translation instruction that you use to create the column. For example, Figure 4-6 shows the column properties for a dynamic column, [TotalInStock]. It was created using the translation instruction, Expression. The Derived property displays Expression.
BIRT Analytics uses the term permanent column to describe a column that contains data values. You typically load the data values in a permanent column from an external database. You can transform a dynamic column to a permanent column using the transformation instruction, MAKEPERMANENT. For more information about transformations, see Transforming data.
Figure 4-6  

Additional Links:

Copyright Actuate Corporation 2013 BIRT Analytics 4.2