Period parameters

This table lists the period parameters applicable for the Pivot Editor report:
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.