<p>I am testing out the use of BIRT as a reporting tool and connecting to an Amazon Redshift database. When I create a new data set and input the query, I seem to be getting errors if my query uses temporary tables. </p>
<p> </p>
<p>Is this a known limitation of BIRT? Is there any way to get around this that doesn't include using a stored proc (Redshift doesn't allow stored procs at this point in time)? </p>
<p> </p>
<p>BIRT looks like a good tool, but if it can't handle temp tables its usefulness is severely limited.</p>
<p> </p>
<p>Thanks.</p>
