Updating Cost Sheet Columns in a Shell

Cost sheet columns can be updated in CBS code-based shells.

The Update Shell process runs in the background. Depending on the number of records and shells you are updating, it can take a considerable amount of time to complete. The process is complete when the End Date column in the Shell History window shows the complete date.

Notes:

A column is identified by a unique data source.
If the cost sheet does not exist in the shell, the column is not added.
If the shell cost sheet is present but the column does not exist, the column definition is created, and the column is added. Column restrictions are added. Users/Groups are created or updated.
For formula columns, the system adds the columns or data sources to the destination cost sheet if they do not exist. If column formulas contain data sources that are not other explicit columns and thus not visible, these data sources are applied in the same manner and remain hidden in the destination. Formula-based columns that are based on BPs are not automatically updated if you change the name of the BP. To update the hover label, you can use the Update Shells feature. You can also right-click the column name, select Properties, click Select in the Formula section, and make the applicable changes.
Any new column that is created will use the column to its immediate left as the reference point for positioning. When a column is added to the cost sheet via an update, this means: If the column to the left of the column that is being pushed exists in both the template and cost sheet, the column is positioned in the cost sheet according to its position in the template. If the column to the left of the column being pushed exists in the template but does not exist in the cost sheet, the column is added to the end (far right) in the cost sheet.

Related Topics