Worksheet parameters for the ORDER and HEAD functionality

New worksheet parameters are added to the pivot_editor report to define a subset of elements for display, ordered by specified measure values. This enhancement supports alignment order of multiple dimensions on worksheet rows (left) or worksheet columns (top).

These parameters are added:

rv_order_top (Top Order)
rv_order_left (Left Order)
rv_head_top (Top Results)
rv_head_left (Left Results)

ORDER parameters are in the format of an MDX expression containing some element selection and sort order in the format, Expression, Sort Order. For example: ([%measures%].currentmember,[Current Year]),BDESC

Order elements on the dimension by the selected values of the measure for Current Year in descending order, disregarding the hierarchy.

HEAD parameters accept a numerical value indicating the first ’x’ number of results returned to display in the dimension. When used in conjunction with ORDER, this displays the top or bottom "x" results.

By default, this feature is enabled. No additional role or privilege is required to access this feature. This feature is available to those users with access to configure calendars.