Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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)

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

Labels in this area