Thanks for the response Gianni. So, regarding get rid of your EVALUATE - how do I get rid of EVALUATE? Is there any way I can use an analytic function without EVALUATE or any OBI function which performs the same task that I don't know of? Please explain. "value" column is a measure? - I'have both the columns in…

Thanks for all your efforts and special thanks to you @Syed Hamd Salman! However, none of these suggestions worked. So we raised an SR with Oracle and they confirmed, it's a bug and suggested to wait until next releases! Thanks, Sravan

Based on the sample data above, I can suggest you to use MIN or MAX functions for appt time column grouping other columns. Syntax : MIN[or MAX](appt time BY *all other columns*)

Yea, tried that as well! No luck

Thanks for reply Salman. These are the current permissions I've on the project.

Thanks for the approach. I've already come across this, but this approach is something which we do from local machine. I'm looking for some way that can be don at BI server level itself. Like, instead of using the Catalog Manager client tool, I can generate the catalog metadata using ./runcat.sh script(in BI server).…

Yup and that's what i stated in the question clearly. "When executing the same query which OBIEE has generated in sqldeveloper with the same connection pool defined in the repository, it works fine. "

Hi, Thanks for the response. Yes, the option is checked but still the report throws an error. I have a new role created for this. I am just letting the Role to Read/Write. Should there be anything more than this?