Wow, i finally solve the issue by using COUNT instead of COUNT DISTINCT; that sounds mysterious. Does anyone know what happen to the COUNT DISTINCT? is this a bug of OBIEE 11 ?

Hi Jay Gandhi, thanks for your reply! There's no any hidden column in Criteria! If converted to query, this is the simple SQL with group by on columns so i couldn't understand why the measure is splitting into two rows, as you can see other columns are exactly the same. The query doesn't give double row when running in SQL…

Thanks Christian Berg, sorry for late reply! Yes, the base data is in only one physical table in database, i use a count distinct on measure column and a grand total after. I looked into the log file but could not found any issue on the aggregation or combination. Below is the log file, pls help to check if i missed…