ICalendarDimensionClass.Month

Syntax

Month(Calendar: IDimInstance; El: Integer): Integer;

Parameters

Calendar. Data of the calendar dictionary, by which calculation is executed.

El. Index of the element, relative to which calculation is executed.

Description

The Month method returns index of the element corresponding to the month, which includes the specified element.

Comments

For correct calculation the calendar dictionary must contain the Months level. If the level is missing, the method returns -1.

For example, if the calendar dictionary contains the Quarters, Months, Days levels and the calculation is executed for:

Element of the quarter frequency, the Month method returns the element corresponding to the first month of the quarter.
Element of the daily frequency, the Month method returns the element corresponding to the month, which includes the day.

Example

The method use is identical to the the use in the example for ICalendarDimensionClass.Day.

NOTE. To execute the example, replace the Day method with Month. Make sure that the repository contains a table with data by months or days and a calendar dictionary containing the Months level, and determine corresponding settings for standard cube.