The update manager enables the user to change the view, mode and order of displaying update objects:
To set up displaying of objects in the update structure, click the
Display Objects button and select display option in the drop-down menu:
Name. Default value. Objects are displayed with their names.
Identifier. Objects are displayed with their identifiers.
Name and Identifier. Objects are displayed with their names, object identifiers are displayed in brackets.
Object order is important when creating an update. Add or place the added objects in the update structure starting with parent objects or sources, which are absent in the target repository, and finishing with objects that were created on their basis.
Before saving the update, the dialog box prompting to confirm object sorting opens. If the answer is positive, objects will be automatically sorted, otherwise the object order remains the same.
To reorder objects:
Use the
Move Up,
Move Down, or
Move One Level Up buttons on the toolbar. The
Move Up and
Move Down buttons move the object within one level.
Select update object sorting method in the drop-down menu of the
Arrange objects by Dependency button on the toolbar:
By Type. Objects are arranged by type.
By Dependency. The option arranges objects on the panel in the order of their dependency not breaking folders composition (contents). Repository objects and object deletion are arranged. Repository objects are arranged in the following order: first, basic objects, then the objects created on their basis (for example, tables, dimensions, cube). Deletion objects are arranged in the reverse order: first, independent objects based on other objects, then objects included in the earlier listed objects (for example, cube deletion, dimension deletion, table deletion). Comments, SQL commands, security subjects and special objects are not arranged.
Allow Structure Violation. The option arranges objects on the update panel in the order of their dependency, breaking their structure. Objects are arranged similarly to the By Dependency option, but if required, objects can be placed outside folders, in which they are located. This rule does not cover container objects, for example, modeling container, their child objects cannot be placed outside their borders.
NOTE. These commands are available only when the objects are displayed in the order they have been added to the update.
Select the Move Up, Move Down, Move One Level Up, and Move One Level Down items in the update object's context menu.
Use Drag&Drop.
To show or hide columns in the update structure:
Click the
Display Objects button.
Select or deselect columns:
Update Object Type. Available values: Folder, Repository Object, SQL Command, Delete Repository Object, Security Subject. Update object type is determined automatically.
Object Class.
Object Key.
Object Identifier.
Object Version.
Date Modified.
Transfer Data. Available value: Partial. Column value is displayed to determine whether the object is partially updated.
Update Condition. The available value: the update condition formula specified on the object update options panel.
The values specified in the columns: Object Class, Object Key, Object Identifier, Object Version, and Date Modified correspond with object properties.
After executing the operations the selected columns are displayed in the update structure.
See also: