Linking Unv with Excel data in Webi Rich Client after WIS 30351 error
- Web Intelligence Rich Client
- 2 x Data Providers:
- 1 x Universe data
- 1 x Excel spreadsheet
I created both queries in Web Intelligence Rich Client and merged the common dimensions, [Address Number] without any issues. My problem started when I tried to change the unique dimension, [Long Address], in the Excel data provider to a detail object (associated to the merged object, [Address Number]) but got the following error: Web Intelligence cannot build the query or generate the report. (WIS 30351)
I tried various recommendations from SCN on error WIS 30351 without success.
In the end I found a fix\work-around on the report level by creating a new variable, [Long Address Detail] (Qualification: Detail) from the original dimension [Long Address] and then associating it with merged\linked dimension [Address Number]:
This allowed me to display data from both data providers, Universe and Excel spreadsheet, in 1 report linked on the [Address Number] .
Hope this helps