Period parameters

Field	Name	Default	Description
rv_period_passed	Period Passed	No	The list of periods that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. If not defined the data context of the specified module is used.
rv_period_drilldown	Periods Show Children	True	Indicates if both the passed period element and the children are displayed in the worksheet when uploaded, wherein the period selection is a single element or a set, and the period dimension exists on the pivot (not the slicers). For example, Passing [FY 2014] displays the period FY 2014 and the child level quarters: FY14 Qtr1, FY14 Qtr2, FY14 Qtr3, FY14 Qtr4 on the pivot. Default = True. When False only the selected passed period is displayed. When a set of elements is passed for the selected period, the elements of the set are displayed on the pivot, irrespective of the parameter value. When the period dimension is within the slicer (extension of a pivot table) area, only the passed element or default member in the selection is displayed; irrespective of the parameter value.
rv_period_except	Periods Hidden on Pivot	None	The list of periods that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_period_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is considered. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_period_passed are displayed.
rv_period_lock	Periods Edit Lock	None	The list of periods that are locked. The ascendants or descendants of the periods are also locked. This is a subset of rv_period_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. For example, rv_period_lock = [FY 14 Qtr1] locks: Ascendants: FY 2014 and "Monthly Calendar" (calendar name / aggregate). Descendants: FY14 M01, FY14 M02, FY14 M03. If not defined, all the elements in rv_period_passed parameter can be edited.

rv_period_passed

Period Passed

No

The list of periods that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. If not defined the data context of the specified module is used.

rv_period_drilldown

Periods Show Children

True

Indicates if both the passed period element and the children are displayed in the worksheet when uploaded, wherein the period selection is a single element or a set, and the period dimension exists on the pivot (not the slicers). For example, Passing [FY 2014] displays the period FY 2014 and the child level quarters: FY14 Qtr1, FY14 Qtr2, FY14 Qtr3, FY14 Qtr4 on the pivot. Default = True. When False only the selected passed period is displayed. When a set of elements is passed for the selected period, the elements of the set are displayed on the pivot, irrespective of the parameter value. When the period dimension is within the slicer (extension of a pivot table) area, only the passed element or default member in the selection is displayed; irrespective of the parameter value.

rv_period_except

Periods Hidden on Pivot

None

The list of periods that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_period_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is considered. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_period_passed are displayed.

rv_period_lock

Periods Edit Lock

None

The list of periods that are locked. The ascendants or descendants of the periods are also locked. This is a subset of rv_period_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. For example, rv_period_lock = [FY 14 Qtr1] locks: Ascendants: FY 2014 and "Monthly Calendar" (calendar name / aggregate). Descendants: FY14 M01, FY14 M02, FY14 M03. If not defined, all the elements in rv_period_passed parameter can be edited.