GETPARTITIONOTLCHANGESEX

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.

Note:

All arguments must be provided on one line.

Syntax

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

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

dataFlowDirection

The half of the partition to which you are currently connected:

1 - Source 2 - Target

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:

GETPARTITIONOTLCHANGESEX "BAMBOO" "SAMPLE" "BASIC" 
"1" "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:

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

See Also

  • APPLYOTLCHANGEFILE