The Transform—Repository’s structure, shown in Figure 5‑6, shows the databases, their tables, and columns. Use this panel to drag the name of FastDB objects such as databases, tables and columns and drop them into transformation instructions. Double-click a column name to explore the column properties and discrete values.
Figure 5‑6 Repository’s structure panel
Refresh the repository content.
Get derived column definitions.
Displays a list of the derived columns in the selected database. These columns were added by analysts using Loader or BIRT Analytics and are not permanent.
Figure 5‑7 Getting a derived column definition
Analysts create derived (calculated) columns during the data analysis. BIRT Analytics Loader administrators can add these columns to the tables when refreshing the data during the load process. If derived columns are not made permanent, the definitions of these columns are lost, and must be recreated.
How to make a derived column permanent
Log in to Loader to complete the following instructions:
1 In Transform—Repository’s structure, choose Get derived column definitions.
2 In Get derived columns definitions, disable any columns that you do not want to become permanent.
3 Choose OK.
4 The new columns appear in the Transform—Main file list of loading instructions. The the new permanent columns are included the next time you run the loading instructions.
Refresh the repository content.
