GETPARTITIONOTLCHANGES

Retrieves a list of outline changes made to the partitioned area in the source database, and writes these changes to the .CHG file on the target database you select with the SELECT command.

If the database has multiple partitions of the same type to the same target database or from the same source database, use GetPartitionOtlChangesEx instead, and specify the data direction.

Note:

All arguments must be provided on one line.

Syntax

GETPARTITIONOTLCHANGES sourceServerName sourceAppName
  sourceDbName sourcePartitionType getAllOtlChanges
 [
  getAllDimChanges
  [getNewDim getDeletedDim getUpdatedDim getMovedDim
  getRenamedDim]
  getAllMbrChanges
  [getNewMbrs getDeletedMbrs
  getRenamedMbrs getMovedMbrs]
  getAllMbrAttribChanges
  [getChngedMbrStatus getChngedMbrAlias getChngedMbrCalcSym
  getChngedMbrAcctType getChngedMbrCurrCnvInfo
  getChngedMbrUda getChngedMbrCalcFormulas]
  getChangedLevNbr
  getChangedGenNbr
 ]

Parameter	Description
sourceServerName	Name of the data source server where the outline changes were made.
sourceAppName	Name of the data source application where the outline changes were made.
sourceDbName	Name of the data source database where the outline changes were made.
sourcePartitionType	Name of the partition type where the outline changes were made. Can be any of the following: 1 - Replicated 2 - Linked 3 - Transparent
getAllOtlChanges	Lists all changes to the database outline. Values: Y/N.
getAllDimChanges	Lists all changes to the dimensions, including member names. Values: Y/N.
getNewDim	Lists newly created dimensions. Values: Y/N.
getDeletedDim	Lists deleted dimensions. Values: Y/N.
getUpdatedDim	Lists updated dimensions. Values: Y/N.
getMovedDim	Lists moved dimensions. Values: Y/N.
getRenamedDim	Lists renamed dimensions. Values: Y/N.
getAllMbrChanges	Lists all member changes. Values: Y/N.
getNewMbrs	Lists newly created members. Values: Y/N.
getDeletedMbrs	Lists deleted members. Values: Y/N.
getRenamedMbrs	Lists renamed members. Values: Y/N.
getMovedMbrs	Lists moved members. Values: Y/N.
getAllMbrAttribChanges	Lists all changes to member attributes. Values: Y/N.
getChngedMbrStatus	Lists members that have a changed status such as data storage or Dynamic Time Series information. Values: Y/N.
getChngedMbrAlias	Lists changed member aliases. Values: Y/N.
getChngedMbrCalcSym	Lists changed member unary operators. Values: Y/N.
getChngedMbrAcctType	Lists changed account type information for members in an Accounts dimension. Values: Y/N.
getChngedMbrCurrCnvInfo	Lists changed member currency conversion information. Values: Y/N.
getChngedMbrUda	Lists changed member user-defined attributes. Values: Y/N.
getChngedMbrCalcFormulas	Lists changed member calc formulas. Values: Y/N.
getChangedLevNbr	Lists changed level numbers. Values: Y/N.
getChangedGenNbr	Lists changed generation numbers. Values: Y/N.

Notes

This command retrieves a list of all outline changes made to the data source database, based on the selected parameters, and writes the changes to a .CHG log file on the selected data target database. Essbase creates the .CHG file, and names it with a file name representing the partition ID.

Example

With Optional Parameters:

GETPARTITIONOTLCHANGES "BAMBOO" "SAMPLE" "BASIC" 
"1" "N" "Y" "Y" "Y" "N" "Y" "Y" "N" "Y" "Y" "N" "Y" "N" "Y" "Y" "Y" "Y" "N" "Y" "Y" "Y" "Y";

Without Optional Parameters:

GETPARTITIONOTLCHANGES "BAMBOO" "SAMPLE" "BASIC" 
"1" "N" "Y" "Y" "Y" "Y";