#MultiValue Error after merging 5 data providers

Hi All,

I have got to create a report with 5 data providers. They are linked using merged dimensions.

Please find attached document containing screenshots of all 5 data providers and the merged dimensions created. I have also attached a copy of the report exported to excel with sample data.

The issue is that the detail data is being duplicated on “Partner Audit-Detail”
Tab. I have turned on the “Avoid Duplicate Rows Aggregation” block property. However, when I turn that flag off, I get the #MultiValue error.

Can anybody offer insight into it and help me eliminate the issue.

Many Thanks !!

Regards,
Rahul
Sample_Report.zip (149.0 KB)
Report_Objects_Screenshots.doc (187.0 KB)


swami99raj (BOB member since 2008-04-15)