Fixing A Server Complex Aggregate In OBIEE 11g Error.

Asked By Steve S Billings 0 points N/A Posted on - 07/03/2019

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?

• Status: Open
• Question Views: 67
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Hardware
• Question Tags: Server

Answered By Rony Tin 5 points N/A #319225

Fixing A Server Complex Aggregate In OBIEE 11g Error.

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.

About Rony Tin

Questions
1

Answers
13

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 07/03/2019
• Question Category: Server Hardware