The frequency of updates is controled via the Dimension or Cube screens in CoreBUILD. Updating dimensions daily will cause no issues, it will check the source each night and update the lists to reflect any new elements. Updating cubes Daily could cause issues though, the data volumes associated with monthly snapshot data can cause issues […]
A dimension update is the structure data. Lists of accounts, cost centres, etc. Loading cube data is the period specific data. January Balances, etc. If a cube load is bringing data into CoreBIS for an element (i.e account) that does not exist an error will occur. For this reason we always update dimensions before cubes.
A dimension can only be deleted if it is not used by a cube and has not been locked by a historical submission process.
This button executes the overnight update procedure manually. The process looks for any dimensions that are to be updated today. So if the “Auto Update” is set to “Y” then the process will review the “Update Frequency” and “Update Start Date” to determine if this dimension should be updated, and if so will update it.
Make sure the dimension is “Updated From” a source other than MANUAL
In the CoreBUILD > Dimensions screen the user can click in the “View Members” column next to the dimenson they want to review.