SplashValue

Splashes a value to underlying base cells.

Syntax

«Tuple» SplashValue {0|1|2|3|4|5|6}, «Tuple»,[ «Tuple»,] «Numeric Expression», «Logical Expression», «Numeric Expression», «Logical Expression»

The parameter names are:

  • AllocationMode
  • TargetCell
  • [SourceCell]
  • Value
  • Rounding
  • DecimalPlaces
  • Error Correction

This function has these overloads:

  • This form is used for allocation modes 0, 1, 4, and 5: 
    TargetCell SplashValue(AllocationMode, TargetCell, Value, Rounding, DecimalPlaces, ErrorCorrection)
  • This form is used for allocation modes 2, 3, and 6: 
    TargetCell SplashValue(AllocationMode, TargetCell, SourceCell, Value, Rounding, DecimalPlaces, ErrorCorrection)

This table describes the parameters:

Parameters Description
Allocation Mode
0 Equal
1 Weighted
2 External weighted
3 External weighted basic
4 Absolute distribution
5 Weighted or equal
6 External weighted delta
TargetCell: «Tuple» Target cell's coordinate, the dimensionality of this tuple must be equal to the number of dimensions in cube.
SourceCell: «Tuple» Source cell's coordinate, the dimensionality of this tuple must be equal to the number of dimensions in cube.
Value: «Numeric Expression» Value
Rounding: «Logical Expression» If it is true, values written to basic cells will be rounded
DecimalPlaces: «Numeric Expression» Count of decimal places used for rounding up to the maximum of six decimal places.
ErrorCorrection: «Logical Expression» If it is true, error correction is done.
Return value: «Tuple», this function returns TargetCell.

Example

This example clears the target area, multiplies all actual values under source cell with 1.1 and copies them to the cells under the target cell: 

SELECT
  SplashValue
  (
    3,
    (
      [PROFIT].[Sales Volume],
      [CURRTYPE].[LC],
      [LEVEL].[IFRS],
      [UNIT].[C1101],
      [VERSION].[Budget],
      [PRODUCT].[AS600/175],
      [TIME].[Q1_2017]
    ), 
    (
      [PROFIT].[Sales Volume],
      [CURRTYPE].[LC],
      [LEVEL].[IFRS],
      [UNIT].[C1101],
      [VERSION].[Actual],
      [PRODUCT].[AS600/175],
      [TIME].[Q1_2016]
    ),
    (
      [PROFIT].[Sales Volume],
      [CURRTYPE].[LC],
      [LEVEL].[IFRS],
      [UNIT].[C1101],
      [VERSION].[Actual],
      [PRODUCT].[AS600/175],
      [TIME].[Q1_2016]
    ) * 1.1,
    1=0, 
    6,
    1=0 
  )
  ON COLUMNS
FROM [SALES]