Do an Essbase send.
Overload Name | Description |
---|---|
Adhoc | Performs an Essbase send operation for an Ad-hoc Essbase view. |
General | Performs an Essbase send operation for an Excel Essbase view. |
Range | Performs an Essbase send operation on a specific range for an Excel Essbase view. |
Performs an Essbase send operation for an Ad-hoc Essbase view.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
EssbaseConnectionID | The Essbase connection ID. |
SendLevelZeroOnly |
Controls whether only level zero member combinations are sent to the database during update operations.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendZerosAsMissing |
Controls whether zeros are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendBlanksAsMissing (8.0) |
Controls whether blanks are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseMemberNamesAndAliasesForRows (8.0) |
Controls whether to use member names and aliases for the row dimension. If left blank the View's setting for UseMemberNamesAndAliasesForRowDimensions will be used.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Performs an Essbase send operation for an Excel Essbase view.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendPolicy |
Indicates whether only the active sheet, or all sheets, or all retrieve ranges should be sent when performing an Essbase send operation.
Specify one of the following values or an arbitrary value:
<blank> None ActiveSheet AllSheets SendRanges
|
SendLevelZeroOnly |
Controls whether only level zero member combinations are sent to the database during update operations.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendZerosAsMissing |
Controls whether zeros are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendBlanksAsMissing (8.0) |
Controls whether blanks are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseMemberNamesAndAliasesForRows (8.0) |
Controls whether to use member names and aliases for the row dimension. If left blank the View's setting for UseMemberNamesAndAliasesForRowDimensions will be used.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Performs an Essbase send operation on a specific range for an Excel Essbase view.
Argument | Description |
---|---|
SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank> SheetName SheetNumber AllSheets
|
SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
Address | The address of a range to select for the execution of the method. |
CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
RangeName | The range to do the Essbase Send on. |
EssbaseConnectionID | The Essbase connection ID. |
SendLevelZeroOnly |
Controls whether only level zero member combinations are sent to the database during update operations.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendZerosAsMissing |
Controls whether zeros are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
SendBlanksAsMissing (8.0) |
Controls whether blanks are replaced with the missing string by a Send operation.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
UseMemberNamesAndAliasesForRows (8.0) |
Controls whether to use member names and aliases for the row dimension. If left blank the View's setting for UseMemberNamesAndAliasesForRowDimensions will be used.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|