Skip to Content
0
Former Member
Nov 09, 2012 at 01:09 PM

Custom SQL in WebI

863 Views

Hi,

Is it possible to give custom sql script in WebI especially when 'multiple SQL statements for each context' is checked? I tried giving it, but the SQL script reverts to the system generated script while clicking on 'run query'. Please let me know if someone has tried this before.

Secondly, I have contexts for 2 fact tables because they were linked to common dimension tables. And I was facing the same issue as mentioned above, so I had unchecked that option :'multiple SQL statements for each context'. And a single query was generated at WebI, which allowed me to edit the SQL there.

And the report was generated with desirable output. But very next day, it started displaying an error:

"The query cannot be run, because it contains incompatible objects. See your Business Objects administrator. (Error: WIS 00008)"

After that I had to check that option again, because the same was suggested in some site. But now I am not able to give custom sql there in WebI.

Please let me know if someone has encountered the same issue previously.