INCRESTRUC

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.

Syntax

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).

Description

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
INCRESTRUC Sample Basic FALSE
enables incremental restructuring for all databases except Sample Basic.

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.

Examples

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