Changes the time on the Essbase you selected with the SELECT command, to match the time on another Essbase Server.
Syntax
RESETOTLCHANGETIME fromPartition toPartition
Parameter | Description |
---|---|
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:
|
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