ICalculatedCubeClass.ShiftVal

Syntax

ShiftVal(Coord: ICalculatedCubeInstanceCoord; Lag: Integer): Variant;

Parameters

Coord. Coordinate, relative to which shift is executed.

Lag. Lag, with which a coordinate must be shifted.

Description

The ShiftVal method returns the value by the coordinate shifted relative to the specified coordinate by the calendar dimension with the specified lag.

Comments

This method is used in application macros that calculate values by the current coordinate in a calculated cube.

Example

This example is a macro for a calculated cube.

Function TestFunction(InputCoord: ICalculatedCubeInstanceCoord): Variant;
Var
    Val: Variant;
Begin
    Val := CalculatedCube.ShiftVal(InputCoord, -1);
    Return (Val As Double) * 10;
End Function TestFunction;

On executing the macro the tenfold value of the succeeding coordinate will be returned as the current value.