Specifies whether incremental restructuring is enabled for a database. You can enable incremental restructuring for individual databases or for all databases.
This setting does not apply to aggregate storage databases.
INCRESTRUC [ appname [ dbname] ] TRUE | FALSE
appname | Application name. Optional parameter for enabling incremental restructuring for one or all databases in an application. This parameter may be used in combination with dbname. If you omit appname, you cannot specify dbname, and INCRESTRUC will be enabled for all applications and databases. See Example below. |
dbname | Database name. Optional parameter for enabling incremental restructuring for an individual database. This parameter must be used in combination with appname. If you specify dbname, you must also specify appname. See Example below. |
TRUE | When you make certain outline or dimension changes that normally result in immediate database restructuring, Analytic Services defers restructuring until the next time it accesses the affected blocks. See Notes below. |
FALSE | Analytic Services immediately restructures the database whenever an outline or dimension change calls for it. The default value is FALSE (for all databases). |
xxxxx
to indicate "all" for
any application or database argument. For example:INCRESTRUC xxxxx Basic TRUE
This setting specifies whether incremental restructuring is enabled for a database. You can enable incremental restructuring for individual databases, for all databases in an application, or for all databases on a server.
If you make certain outline or dimension changes that normally result in immediate database restructuring, Analytic Services defers restructuring until the next time the affected block is accessed, or until a full restructure is forced (e.g., by a full calculation). For example, if you add a member to any dimension, or delete a member from a dense dimension, Analytic Services defers restructuring when you enable INCRESTRUC.
When incremental restructuring is enabled, Analytic Services defers restructuring if you change the database outline or a dimension in a way that does not cause structural changes.
The following changes result in incremental (deferred) restructuring:
Restructuring for Dynamic Calc members is different from restructuring for Dynamic Calc And Store members. In general, Dynamic Calc And Store members have a greater impact on restructuring.
The following changes result in immediate restructuring, regardless of whether incremental restructuring is enabled:
If an incremental restructure has already occurred and shared members are added to the outline, Analytic Services ignores the INCRESTSRUC setting and performs a full restructure.
Analytic Services logs outline changes in an internal file, database_name.ocl
.
Analytic Services clears the file whenever it does a full database restructure or when
you clear or reset a database.
The database_name.ocl
file can grow quite large in the meantime.
To clear this file, issue VALIDATE in ESSCMD. VALIDATE causes Analytic Services to restructure
any blocks whose restructure was deferred, and clears the file. When you issue
VALIDATE, make sure the database is not in Read-only mode (Read-only mode is
used for archiving).
If set to TRUE, INCRESTRUC affects all databases in all applications on the Analytic Server (except databases containing LROs), unless you have specified an appname and dbname.
The settings for INCRESTRUC are applied according to their order of appearance
in the essbase.cfg
file. For example:
INCRESTRUC TRUE
enables incremental restructuring for all databases
except Sample Basic.
INCRESTRUC Sample Basic FALSE
If you are using Linked Reporting Objects (LROs) in a database, incremental restructuring is automatically disabled on that database. When you have incremental restructuring enabled for all databases in all applications (that is, you have set INCRESTRUC to TRUE), the presence of an LRO in a database disables incremental restructuring for that database, but does not affect the other databases on the Analytic Server.
If you add shared members to an outline, incremental restructuring is automatically turned off. If a restructure is triggered by outline changes, it will be done.
For more information about incremental restructuring, see the Database Administrator's Guide.
INCRESTRUC Sample Basic TRUE
causes Analytic Services to defer restructuring the Basic database in the Sample application, whenever certain outline or dimension changes are made, until the next time Analytic Services accesses the affected blocks; that is, it enables incremental restructuring for that database.
INCRESTRUC Sample TRUE
causes Analytic Services to defer restructuring for all databases in the Sample application, whenever certain outline or dimension changes are made, until the next time Analytic Services accesses the affected blocks; that is, it enables incremental restructuring for those databases.
INCRESTRUC TRUE
causes Analytic Services to defer restructuring all databases, whenever certain outline or dimension changes are made, until the next time Analytic Services accesses the affected blocks; that is, it enables incremental restructuring for all databases in all applications on that server.
INCRESTRUC FALSE
causes Analytic Services to immediately restructure all databases whenever an outline or dimension change calls for it; that is, it disables incremental restructuring for all databases in all applications on that server.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |