Multi-Select on Other Dimensions in Jedox

Quick post on how to select multiple elements in a filter that is outside the dynarange. I.e., if the dynarange shows products by month and the user wants to show multiple customers or channels.

This can be done using SUM and PALO.DATAV and writing the TRANSPOSE function around the element. It will sum the data for all selected elements.

Note maximum of two arrays can be used, and data cannot be written to a cell using the formula.

Use a listbox to create a list where multiple elements can be selected.

The image below shows how the formula works with a multi-select list for customer:

And then when the report's fired up, the user can select multiple customers. The value for selected customers will be added together:

The only thing to be aware of when using this is it won't work for different elements in the same hierarchy – i.e., selecting "All Customers" and "East" would add the two together when "East" is already included in "All Customers".