Analytics Software

I encountered a syntax error when running a report with the help of advanced filter concept.
I am getting syntax error at the physical query generated by the OBIEE for main report.
I used a sub report with the help of advanced filter concept in main report.

I am posting the physical query for the convenience.

select D1.c2 as c1,
D1.c1 as c2
from
(select sum(T600347.sales_usd) as c1,
T601002.currency as c2
from
(Select distinct currency from pfact) T601002,
pfact T600347
where ( T600347.currency = T601002.currency and T600347.pdate between ( select distinct min(D1.c1) as c1* from

(select D1.c1 as c1
from

(select D1.c1 as c1
from

*(select max(T600425.pdate) as c1*
from

*(select distinct pdate from pdates where pdate is not null) T600425*
where ( T600425.pdate < 11/22/2010 )

*) D1*
) D1
) D1 ) and '11/25/2010')
group by T601002.currency
) D1





I executed the query against my database(sybase) in query tool. It showed error.
I took out the column alias generated by the OBIEE ("as c1" as underlined). Then the query is working fine.
How to disable OBIEE from generating the alias.
Is there any way to do it.

If obiee is generating the physical query, i am suprised to see a syntax error.

The bold part is the query from Intermediate report
I underlined the problematic part.

Please help me. This is an urgent reuirement,

Thanks in advance for the help.