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.
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.