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.

Syntax

NOTE: All arguments must be provided on one line.

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
]

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.

Description

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. Analytic Services 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";

See Also

APPLYOTLCHANGEFILE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com