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.
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. |
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.
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";
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |