Skip to Content

Hi,

My scenario:

  • 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)

Excel detail error.jpg

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]:

Detail obj.JPG

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

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply