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: