you are right Christian, but the dashboard was used for 4 years. right now I am helping to tune it. actually it is impossible to provide different solution. no any tune way in OBIEE?

Run that query in the DB via SQL*Plus from the OBIEE server : only spent 25s

user required these columns. they want to down load the cvs files from Insight.

Thanks ,Yes I saw that ,but I confuse how to improve that?

Thanks .I think the type report logic is showing the sql time in Administartion , could you help to explain why the type DXEExecution is very slow ?

no performance in DB

Thanks Christiam, could you share more detail ?

I already mentioned the query only run 12s on db no performace issue