1207514 - Incorrect sum appears in Web Intelligence when using merge dimension and measures from different contexts

In BusinessObjects Enterprise XI Release 2, an incorrect sum appears in Web Intelligence reports when using a merge dimension and measures from different contexts.

This behavior occurs under the following condition:

• two (or more) separate data providers (for example, DP1, DP2, DP3) are used
  
  -AND-
  
  
• a table is built based only on dimensions from one data provider (DP1) and measures from two (or more) data providers (DP2 and/or DP3).

Unmerged dimensions from DP2 appear in the table. This behavior occurs due to the following:

• Avoid Duplicate Aggregation Table Property is checked even if the underlying query for DP1 delivers no rows for a specific combination of columns in Table1.
  
  However, the underlying query for DP2 returns a result row. This row with a measure from DP2 will be included in the table providing calculation on a measure from DP2 to be correct.
  
  
• Avoid Duplicate Aggregation Table Property is not checked if the underlying query for DP1 delivers no rows for a specific combination of columns in Table1.
  
  However, the underlying query for DP2 delivers a result row. This row with a measure from DP2 will not be included in the table, but will take part in calculations for this measure. It provides an unexpected result (for example, Sum).

To reproduce this behavior using the sample database from Island Resort Marketing:

1. Create a Web Intelligence report based on Island Resort universe.
2. Use the following object for Query 1:
   
   Year/ Resort/Country/Revenue/Number of Guests
   
   
3. Use the following object for Query 2:
   
   Country/Resort/reservation Year/Future guests
   
   
4. Execute the queries.
5. Insert a new report.
6. Use the following object:
   
   Country (from DP2)/Resort (from DP2)/Future guests (from DP2)/ Revenue (from DP1)

When the Avoid duplicate row option is selected, some values for Future guests columns are empty. However, revenue appears for that line.

Therefore, applying a sum on the revenue takes into account those lines on which no Future guests values are present.

Incorrect sum merge dimension , 986113 , KBA , BI-RA-WBI , Web Intelligence , Product Enhancement