public class CustomCalcParameters
extends java.lang.Object
Example call from Groovy:
/*RTPS: {curYear}*/ CustomCalcParameters calcParameters = new CustomCalcParameters() calcParameters.pov = 'Crossjoin(Crossjoin(Crossjoin(Crossjoin(Crossjoin( Crossjoin(Crossjoin({[Jan]},{${mdxParams(rtps.curYear)}}),{[Current]}), {[BU Version_1]}),{[No Currency]}), {[No Entity]}),{[No Manager]}),{CHILDREN([Total Employees])})' calcParameters.script = '([Salary]) := 5000;' calcParameters.roundDigits = 2 operation.getApplication().getCube('HP1_ASO').executeAsoCustomCalculation(calcParameters)
Modifier and Type | Class and Description |
---|---|
static class |
CustomCalcParameters.DataLoadOption
An enumeration containing a list of valid data load options to be used
in custom calc.
|
Constructor and Description |
---|
CustomCalcParameters()
Constructs new instance of this class.
|
Modifier and Type | Method and Description |
---|---|
CustomCalcParameters |
setCreditMember(java.lang.String creditMember)
Specifies an MDX member expression indicating the member to which negative
result values are written, if double-entry accounting is used.
|
CustomCalcParameters |
setDataLoadOption(CustomCalcParameters.DataLoadOption dataLoadOption)
Specifies how the calculated data is handled.
|
CustomCalcParameters |
setDebitMember(java.lang.String debitMember)
Specifies an MDX member expression indicating the member to which positive
result values are written, if double-entry accounting is used.
|
CustomCalcParameters |
setOffset(java.lang.String offset)
Specifies an optional MDX tuple defining the location where an offsetting
value is written for each source amount.
|
CustomCalcParameters |
setPov(java.lang.String pov)
Specifies an MDX set specifying the region in which the calculation
is performed.
|
CustomCalcParameters |
setRoundDigits(int roundDigits)
Specifies the number of digits to round.
|
CustomCalcParameters |
setScript(java.lang.String script)
Specified the MDX script to be executed.
|
CustomCalcParameters |
setSourceRegion(java.lang.String sourceRegion)
Specifies an MDX set specifying the region referred to by the
formulas in the script.
|
CustomCalcParameters |
setTarget(java.lang.String target)
Specifies an MDX tuple defining the region where results are written.
|
public CustomCalcParameters()
public CustomCalcParameters setCreditMember(java.lang.String creditMember)
This parameter is optional. You can specify only stored, level zero members; do not use upper-level members, attribute members, or dynamic calc members.
If credit member or debit member is not specified, debit/credit processing is not performed.
creditMember
- member where credit processing is written topublic CustomCalcParameters setDataLoadOption(CustomCalcParameters.DataLoadOption dataLoadOption)
This option specifies if the value should be added, subtracted or set during the execution of the custom calc.
dataLoadOption
- data load optionpublic CustomCalcParameters setDebitMember(java.lang.String debitMember)
This parameter is optional. You can specify only stored, level zero members; do not use upper-level members, attribute members, or dynamic calc members.
If credit member or debit member is not specified, debit/credit processing is not performed.
debitMember
- member where debit processing is written topublic CustomCalcParameters setOffset(java.lang.String offset)
This parameter is optional. You can use only stored, level zero members in the tuple; do not use upper-level members, attribute members, or dynamic calc members.
offset
- member where offset value is written topublic CustomCalcParameters setPov(java.lang.String pov)
pov
- area of calculationsetScript(java.lang.String)
public CustomCalcParameters setRoundDigits(int roundDigits)
roundDigits
- number of digits to roundpublic CustomCalcParameters setScript(java.lang.String script)
The script will be executed once for every cross-product in the POV region.
script
- custom calc scriptpublic CustomCalcParameters setSourceRegion(java.lang.String sourceRegion)
At a minimum, the source region should include all members from the right-hand sides of the assignment statements in the custom calc script.
sourceRegion
- source regionsetScript(java.lang.String)
public CustomCalcParameters setTarget(java.lang.String target)
This parameter is optional. You can use only stored, level zero members in the tuple; do not use upper-level members, attribute members, or dynamic calc members.
target
- target regionCopyright © 2017, 2024, Oracle and/or its affiliates. All rights reserved.