When we are upgrading to Business Objects XI Release2 Service Pack 5. we are getting #MULTIVALUE error in Web Intelligence reports.
The reason you are getting above error because Data synchronisation option is not checked.
Related: WIS 10901 a Database Error Occurred While Creating Web Intelligence Report
Please do as following:
- First Right-click in the report area, then click Document Properties.
- Then In the Data Synchronization Options area, select the Extend merged dimension values check box.