IsDateEnd(Level:DimCalendarLevel): Boolean;
Level. Calendar level.
The IsDateEnd property determines whether the period start date is replaced with period end date for the specified calendar level.
Available values:
True. Period start date is the period end date. Offset is executed from the period end.
False. Period start date does not change. Offset is executed from the period start.
Offset is available for the following levels:
Years. Level = DimCalendarLevel.Year.
Quarters. Level = DimCalendarLevel.Quarter.
Months. Level = DimCalendarLevel.Month.
Weeks. Level = DimCalendarLevel.Week.
Use the ITsCalendarSettings.OffsetDate property to specify the number of days, to which the data offset of period data start.
This example displays a custom series calculation method. To execute the example, add links to the Dimensions, Ms, Transform system assemblies.
Function OffsetDate(Input: ITimeSeries): ITimeSeries;
Var
pContext: ITsCalculationContext;
i: Integer;
pSeries: ITimeSeries;
CalendSett: ITsCalendarSettings;
Begin
pContext := TsCalculation.Current;
pSeries := pContext.CreateTimeSeries;
CalendSett := Input.CalendarSettings;
If (CalendSett.IsDateEnd(DimCalendarLevel.Year)) And (CalendSett.OffsetDate(DimCalendarLevel.Year) = 1) Then
For i := Input.StartIndex To Input.EndIndex Do
pSeries.Item(i) := 1 + Input.Item(i);
End For;
Else
pContext.RaiseWarning("Used calendar parameters do not fit for method calculation");
End If;
Return pSeries;
End Function OffsetDate;
The method increases values of input series if an offset of the calendar level shifted to the year from the end of the calendar level is used.
See also: