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 ]
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 |
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