Erroneous totalling with OBIEE

During testing procedure of data quality I started to compare data in a DW and source database - I've decided just to check totals and encountered strange behaviour of BI Server totalling feature:

Report shows different values for "Филиал"(Affiliate) (here is a right total) and "Общий итог"(Grand Total) (here is a wrong total). This may be confused to a user, so I investigated the issue. As it turned out, "Наименование услуги"(Service name) was based on a sourse which used "Where Clause":


Grand Total summed not just those values of "Наименование услуги"(Service name) that represented in a report, but included those ones that did not meet condition of "Where Clause" so it resulted in mismatch of totals.
Solving of problem has been found here - http://oraclebi.soundvoid.net/2008/10/grand-totals-with-calculated-columns-2/

I just inserted section

<ReportAggregateEnabled>true</ReportAggregateEnabled>

to a instanceconfig.xml, restarted Presentation Services and got proper result:

Thanx to all.

Pilot

I decided to become blogger here to share my Q&A, news, achievments,dissapointments as a BI consulter. English is chosen to be maximum comprehensible to technical specialists all around the world.
Ivan, Moscow,Russia,2009.