We have a DWH with an inline table as described at http://mondrian.pentaho.com/document...#Inline_tables

This inline table contains 10 rows.

The resulting queries to mySQL is the following
Code:
select `Status`.`status_id` as `c0`, `Escalation`.`escalation_id` as `c1`, `table_user_satisfaction_binned`.`id` as `c2`, count(distinct `IncidentFact`.`incident_id`) as `m0`  from `Status` as `Status`, `Incident_Time_Status` as `Incident_Time_Status`, `IncidentFact` as `IncidentFact`, `Escalation` as `Escalation`, (
select 5 as `id`, '41-50%' as `desc` union all 
select  1 as `id`, '0-10%' as `desc` union all 
select 2 as `id`, '11-20%' as `desc` union all 
select 3 as `id`, '21-30%' as `desc`  union all 
select 4 as `id`, '31-40%' as `desc` union all 
select 6 as `id`, '51-60%' as `desc` union all 
select 7 as `id`, '61-70%' as `desc`  union all 
select 8 as `id`, '71-80%' as `desc`  union all 
select 9 as `id`, '81-90%' as `desc` union all 
select 10 as `id`, '91-100%' as `desc`) as `table_user_satisfaction_binned`
where `IncidentFact`.`incident_id` = `Incident_Time_Status`.`incident_id` and `Incident_Time_Status`.`status_id` = `Status`.`status_id` and `Status`.`status_id` = 4 and `IncidentFact`.`escalation_id` = `Escalation`.`escalation_id` and `Escalation`.`escalation_id` = 1 and `IncidentFact`.`user_satisfaction_binned` = `table_user_satisfaction_binned`.`id` group by `Status`.`status_id`, `Escalation`.`escalation_id`, `table_user_satisfaction_binned`.`id`;
This query takes 6 seconds to execute on mySQL

rewritting this statement to:
Code:
select `Status`.`status_id` as `c0`, `Escalation`.`escalation_id` as `c1`, `table_user_satisfaction_binned`.`id` as `c2`, count(distinct `IncidentFact`.`incident_id`) as `m0` 
from `Status` as `Status`, `Incident_Time_Status` as `Incident_Time_Status`, `IncidentFact` as `IncidentFact`, `Escalation` as `Escalation`, temp_Binning as `table_user_satisfaction_binned` 
where `IncidentFact`.`incident_id` = `Incident_Time_Status`.`incident_id` and `Incident_Time_Status`.`status_id` = `Status`.`status_id` and `Status`.`status_id` = 4 and `IncidentFact`.`escalation_id` = `Escalation`.`escalation_id` and `Escalation`.`escalation_id` = 1 and `IncidentFact`.`user_satisfaction_binned` = `table_user_satisfaction_binned`.`id` group by `Status`.`status_id`, `Escalation`.`escalation_id`, `table_user_satisfaction_binned`.`id`;
This takes just one second.

Should mondrian create a real temp table or should this be mentioned in the documentation? Or do you consider this just as an mySQL issue?

We have spent a long time debugging this.

regards