Because the blocks are no longer pointed to, they become free space. Incremental Restructuring Applies? (If Enabled)ĭata must be recalculated to reflect changes to relationships.Įssbase deletes from the index file all pointers to blocks represented by the deleted member. Table 112. Actions: Delete, Add, or Move MemberĬalculation and Standard Restructure Effects If such a message is displayed, Essbase is performing final cleanup, and it is too late to cancel. If you try to cancel a restructure operation, Essbase may issue a “Can’t cancel” message. This event most likely will occur if you make changes to a sparse dimension. Backup ensures that any abnormal termination during the restructure process does not corrupt the database.Įssbase may display a “Restructuring not required” message yet still perform an index-only restructure. If the database contains data, you need enough free disk space on the server to create a backup copy of the database. See “Saving Outlines” in Oracle Essbase Administration Services Online Help. In the Restructure Database dialog box, you define how data values are handled during restructure for example, you can preserve all data, preserve only level 0 or input data, or discard all data during restructure. See Incremental Restructuring and Performance for a comprehensive discussion of incremental restructuring.Įssbase displays a dialog box when you save outline changes that trigger database restructuring (using Outline Editor). If you change a database outline frequently, consider enabling incremental restructuring. If you use incremental restructuring, Essbase defers dense restructuring. Member name changes, creation of aliases, and dynamic calculation formula changes are examples of changes that affect only the database outline. Outline-only restructure: If a change affects only the database outline, Essbase does not restructure the index or data files. Restructuring the index is relatively fast the time required depends on the index size. Sparse restructure: If a member of a sparse dimension is moved, deleted, or added, Essbase restructures the index and creates new index files. Dense restructuring, the most time-consuming of the restructures, can take a long time to complete for large databases. Essbase marks all restructured blocks as dirty, so after a dense restructure you must recalculate the database. When Essbase restructures the data blocks, it regenerates the index automatically so that index entries point to the new data blocks. Dense restructure: If a member of a dense dimension is moved, deleted, or added, Essbase restructures the blocks in the data files and creates new data files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |