In OBIEE 11g when I calculate whole percentages in link tables and aggregates of large combined values, I get an error, somebody suggested to use ‘server complex aggregate’ what should I do to solve the problem?
This happens when OBIEE is receiving the data from the database, but the report related calculations are being carried in the BI administrator. Hence there is a relative clash in the quantities and answers on average, and the percentage goes wrong. In this, you can receive an aggregate larger than the largest value and a percentage of more than 100. To remove this inaccuracy change the aggregate rule from default to ‘server complex aggregate,’ and refresh the table.
Now in this method, the OBIEE sends data to BI administrator, so the inaccuracy is removed.
It can be seen that the aggregates are now correct and percentages are also under a hundred.
