Item and Location parameters

Field	Name	Default	Description
rv_item_passed	Items Passed	No	The list of items that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main item data context (for the module) for this worksheet. The MDX definition for the set is supported. If not defined the data context of the specified module is used.
rv_item_except	Items Hidden on Pivot	None	The list of items that are not displayed on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of rv_item_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports MDX definition for the set. If not defined, all items specified in the rv_item_passed parameter are displayed.
rv_item_main_attr	Additional Item Attributes	None	A list of item attributes from OLAP that must be displayed, as additional header columns or rows, with each item element in the worksheet. A comma-separated list of up to 3 attributes is used. If the number of attributes is more than 3, the attributes are not considered. The attributes are displayed on the right of the items column (if on the left dimension) or below the items header row (if on the top dimension). If the items are not included on the pivot (left or right dimension), the parameter is ignored. The attribute list is validated during run-time and the attributes must be included in OLAP. Note: These attributes are not required to be pivot attributes. Note:Attributes that are not validated are not included, and the additional column or header is not displayed.
rv_item_attr1	Item Attribute 1 Passed	Full hierarchy	The list of the item 1 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_item_attr1_except	Item Attribute 1 Hidden	None	The list of the item 1 attributes that are hidden on the pivot report and subsequently on the chart,when the worksheet is uploaded. This is a subset of v_item_attr1 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_item_attr1 parameter are visible.
rv_item_attr2	Item Attribute 2 Passed	Full hierarchy	The list of the item 2 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_item_attr2_except	Item Attribute 2 Hidden	None	The list of the item 2 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of v_item_attr2 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_item_attr2 parameter are visible.
rv_item_attr3	Item Attribute 3 Passed	Full hierarchy	The list of the item 3 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_item_attr3_except	Item Attribute 3 Hidden	None	The list of the item 3 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of v_item_attr3 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_item_attr3 parameter are visible.
rv_item_attr4	Item Attribute 4 Passed	Full hierarchy	The list of the item 4 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_item_attr4_except	Item Attribute 4 Hidden	None	The list of the item 4 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of v_item_attr4 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_item_attr4 parameter are visible.
rv_item_attr5	Item Attribute 5 Passed	Full hierarchy	The list of the item 5 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_item_attr5_except	Item Attribute 5 Hidden	None	The list of the item 5 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of v_item_attr5 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_item_attr5 parameter are visible.
rv_location_passed	Location Passed	None	The list of locations that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Supports the MDX definition for the set. Overrides the main location data context (for the module) for this worksheet.
rv_location_except	Locations Hidden on Pivot	None	The list of locations that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_passed parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all elements specified of the rv_location_passed parameter are displayed.
rv_location_main_attr	Additional Location Attributes	None	A list of location attributes from OLAP that must be displayed, as additional header columns or rows, with each location element in the worksheet. A comma-separated list of up to 3 attributes is used. If the number of attributes is more than 3, the attributes are not considered. The attributes are displayed on the right of the location column (if on the left dimension) or below the items header row (if on the top dimension). If the items are not included on the pivot (left or right dimension), the parameter is ignored. The attribute list is validated during run-time and the attributes are included in OLAP. Note: These attributes are not required to be pivot attributes. Attributes that are validated are not included and the additional header is also not included for that attribute.
rv_location_attr1	Location Attribute 1 Passed	Full hierarchy	The list of the location 1 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_location_attr1_except	Location Attribute 1 Hidden	None	The list of the location 1 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_attr1 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_location_attr1 are displayed.
rv_location_attr2	Location Attribute 2 Passed	Full hierarchy	The list of the location 2 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_location_attr2_except	Location Attribute 2 Hidden	None	The list of the location 2 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_attr2 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_location_attr2 are displayed.
rv_location_attr3	Location Attribute 3 Passed	Full hierarchy	The list of the location 3 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_location_attr3_except	Location Attribute 3 Hidden	None	The list of the location 3 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_attr3 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_location_attr3 are displayed.
rv_location_attr4	Location Attribute 4 Passed	Full hierarchy	The list of the location 4 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_location_attr4_except	Location Attribute 4 Hidden	None	The list of the location 4 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_attr4 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_location_attr4 are displayed.
rv_location_attr5	Location Attribute 5 Passed	Full hierarchy	The list of the location 5 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.
rv_location_attr5_except	Location Attribute 5 Hidden	None	The list of the location 5 attributes that are hidden on the pivot report and subsequently on the chart, when the worksheet is uploaded. This is a subset of the rv_location_attr5 parameter. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, all the elements specified for the rv_location_attr5 are displayed.

rv_item_passed

Items Passed

No

The list of items that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Overrides the main item data context (for the module) for this worksheet. The MDX definition for the set is supported. If not defined the data context of the specified module is used.

rv_item_except

Items Hidden on Pivot

None

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

rv_item_main_attr

Additional Item Attributes

None

A list of item attributes from OLAP that must be displayed, as additional header columns or rows, with each item element in the worksheet. A comma-separated list of up to 3 attributes is used. If the number of attributes is more than 3, the attributes are not considered. The attributes are displayed on the right of the items column (if on the left dimension) or below the items header row (if on the top dimension). If the items are not included on the pivot (left or right dimension), the parameter is ignored. The attribute list is validated during run-time and the attributes must be included in OLAP.

Note: These attributes are not required to be pivot attributes.

Note:Attributes that are not validated are not included, and the additional column or header is not displayed.

rv_item_attr1

Item Attribute 1 Passed

Full hierarchy

The list of the item 1 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_item_attr1_except

Item Attribute 1 Hidden

None

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

rv_item_attr2

Item Attribute 2 Passed

Full hierarchy

The list of the item 2 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_item_attr2_except

Item Attribute 2 Hidden

None

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

rv_item_attr3

Item Attribute 3 Passed

Full hierarchy

The list of the item 3 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_item_attr3_except

Item Attribute 3 Hidden

None

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

rv_item_attr4

Item Attribute 4 Passed

Full hierarchy

The list of the item 4 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_item_attr4_except

Item Attribute 4 Hidden

None

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

rv_item_attr5

Item Attribute 5 Passed

Full hierarchy

The list of the item 5 attributes that must be displayed in the worksheet, if defined. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_item_attr5_except

Item Attribute 5 Hidden

None

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

rv_location_passed

Location Passed

None

The list of locations that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} must be defined. Supports the MDX definition for the set. Overrides the main location data context (for the module) for this worksheet.

rv_location_except

Locations Hidden on Pivot

None

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

rv_location_main_attr

Additional Location Attributes

None

A list of location attributes from OLAP that must be displayed, as additional header columns or rows, with each location element in the worksheet. A comma-separated list of up to 3 attributes is used. If the number of attributes is more than 3, the attributes are not considered. The attributes are displayed on the right of the location column (if on the left dimension) or below the items header row (if on the top dimension). If the items are not included on the pivot (left or right dimension), the parameter is ignored. The attribute list is validated during run-time and the attributes are included in OLAP.

Note: These attributes are not required to be pivot attributes.

Attributes that are validated are not included and the additional header is also not included for that attribute.

rv_location_attr1

Location Attribute 1 Passed

Full hierarchy

The list of the location 1 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_location_attr1_except

Location Attribute 1 Hidden

None

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

rv_location_attr2

Location Attribute 2 Passed

Full hierarchy

The list of the location 2 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_location_attr2_except

Location Attribute 2 Hidden

None

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

rv_location_attr3

Location Attribute 3 Passed

Full hierarchy

The list of the location 3 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_location_attr3_except

Location Attribute 3 Hidden

None

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

rv_location_attr4

Location Attribute 4 Passed

Full hierarchy

The list of the location 4 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_location_attr4_except

Location Attribute 4 Hidden

None

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

rv_location_attr5

Location Attribute 5 Passed

Full hierarchy

The list of the location 5 attributes that must be displayed in the worksheet. A single element [element1] or a set in the form: {[element1],[element2]} is required. Supports the MDX definition for the set. If not defined, the entire hierarchy is used.

rv_location_attr5_except

Location Attribute 5 Hidden

None

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