Hi,
My scenario:
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
Gerrie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |