Multiselect

Multiselect enables you to select two or more elements from a hierarchy and to aggregate their values by one of these methods:

  • Sum
  • Min
  • Max
  • Avg
  • Any

Multiselect is available in the Select Element dialog via a select element action, and through these formulas:

  • CELLGET
  • MEMBERCNAME
  • MEMBERGET
  • ROA
  • ROC

Aggregation is not relevant to element attributes so the aggregation method is ignored in ROA formulas.

Writeback is not supported for multiple elements.

Before Application Studio 10.5.0, you could select only individual elements in the Select Element dialog. You can enable multiselect in the Select Element actions of reports which were developed in an earlier version of Application Studio.

In a Select Element action, the selected elements are passed to a variable. If you select multiple elements, they are stored as multiselect XML (MLS-XML). If you select a single element, its unique name is stored in the variable. This is an example of MLS-XML:

<?xml version="1.0" encoding="utf-16"?>
<MultiSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Hierarchy>[Period]</Hierarchy>
  <AggregationFunction>Sum</AggregationFunction>
  <StructureSelection>
    <Member>
      <MemberUName>[period].[all years].[2016]</MemberUName>
    </Member>
    <Member>
      <MemberUName>[period].[all years].[2017]</MemberUName>
    </Member>
  </StructureSelection>
</MultiSelect>
You can use these functions to create, add to, and select from MLS-XML:
  • MULTISELECTADD
  • MULTISELECTCREATE
  • MULTISELECTGETMEMBERS
  • MULTISELECTGETMEMBERSSIMPLE

You can use multiselect in structure selection and filters in the server list designer.