Let us know how we can make Jedox even better!
Today, the view lets you select multiple items from the combo-boxes in the view header.
User can choose between SUM or AVERAGE for aggregation. Measures amounts are calculated accordingly to user's choice.
The same occurs for measures calculated by rules. But it is not the expected behavior. Calculated measures should be calculated according to their definition in cube rules.
Example:
Product Quantity Amount Unit Price (C: [Amount] / [Quantity])
A 100 1000 10
B 50 2500 50
Today, displayed values according to user choice are
SUM 150 3500 60
AVG 75 1750 30
But displayed values should be
SUM 150 3500 23,33
AVG 75 1750 23,33
Rules should be applied even if a multi-selection is made.