Updating a map of a database table or view
In a database, a table or view can change in the following ways:
*
*
*
*
Information Object Designer can detect these changes and update the map of the table or view. You can update a single map, or update several maps at once.
Map column name and data type changes are propagated to dependent information objects if the information object column uses the default name. If the name change would result in a duplicate information object column name, a suffix is added, for example creditLimit_1. A column name is updated in the following tabs in the graphical information object editor if it does not appear in an expression:
*
*
*
*
*
A column name in an expression, for example SUM(quantityOrdered * priceEach), is not updated. If the information object column name has been modified, changes are not propagated.
A column that is added to a map is also added to dependent information objects as a source column. The column is not added to the information object’s SELECT clause. In other words, the column appears in the upper pane of the graphical information object editor, but it is unchecked.
A column that is dropped from a map is not dropped from dependent information objects by default. You must indicate that the column should be dropped. Because this action cannot be undone, back up the project before proceeding.
Map changes are also propagated to dependent cache objects.

Additional Links:

Copyright Actuate Corporation 2012