If you want to see correct calculations – then a BI Server Restart might be required after you change Aggregation Rule for a column from SUM to AVG (or in any way).
I noticed that problem on Grand-Total calculations – it just wouldn’t perform correct aggregation for the column after RPD change in online mode (with Aggregation Rule – Default).
After services restart, OBIEE would perform correct grand-total aggregation.
1 Comment
You do not have to restart the server. All you need is just reload metadata