RESETOTLCHANGETIME

Changes the time on the Essbase you selected with the SELECT command, to match the time on another Essbase Server.

Syntax

RESETOTLCHANGETIME fromPartition toPartition
ParameterDescription

serverName

Name of the Essbase Server from which the time change is applied.

appName

Name of the application from which the time change is applied.

dbName

Name of the database from which the time change is applied.

partitionType

The name of the type of partition from which the time change is applied. Values:

1 - Replicated 2 - Linked 3 - Transparent

direction

Values:

Source - The selected database is used as a data source for the replicated, transparent, or linked partition. Target - The selected database is used as a data target for the replicated, transparent, or linked partition.

serverName

Name of the Essbase Server to get the time change.

appName

Name of the application to get the time change.

dbName

Name of the database to get the time change.

partitionType

The name of the type of partition the time change is applied to. Values:

1 - Replicated 2 - Transparent 3 - Linked

direction

Values:

  • Source - The selected database is used as a data source for the replicated, transparent, or linked partition.

  • Target - The selected database is used as a data target for the replicated, transparent, or linked partition.

Notes

The RESETOTLCHANGETIME command synchronizes the internal time stamps between two Essbase databases that share a partition. This time stamp is used when performing GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations to synchronize the outlines. That is, to propagate changes (made during a dimension build, for example) from the outline in one database sharing a partition to the other.

Partitioned databases contain a time stamp indicating when the outline was last modified. Essbase uses the time stamp when it performs GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations to synchronize the outlines. When you use GETPARTITIONOTLCHANGES, the time is stamped in one of the databases. When you use APPLYOTLCHANGEFILE, Essbase reads that time stamp and writes it TO the partition definition file (AppName.ddb) of the other database. The direction in which changes are propagated (data source to data target, or data target to data source) is set in the partition definition

It is not necessary to use the RESETOTLCHANGETIME command when performing GETPARTITIONOTLCHANGES and APPLYOTLCHANGEFILE operations, or as part of regular maintenance. Instead, use it as needed, to reset the time stamp on a partitioned database. For example, if two databases that share a partition reside on different server computers, and a power outage affects the time stamp on one of the databases, you can use RESETOTLCHANGETIME to re-synchronize the time stamps.

For more information, see the Oracle Essbase Database Administrator's Guide.

Example

RESETOTLCHANGETIME "BAMBOO" "SAMPLE" "BASIC" "1" 
    "SOURCE" "ASPEN" "SAMPLE" "BASIC" "1" "TARGET";

See Also