Have you looked at the SQL this report generates for both cases? Typically it allows to understand what is going on instead of guessing.
SQL is exactly the same
Below are sql , for first i am getting values whereas for second no data
Saw the SQL from advanced tab in analysis
(cast("Start Date"."Start Date" as date) = date '2006-08-01')
(cast("Start Date"."Start Date"as date) = date '2009-05-15')
OK. And what happens when you execute these queries?
I am able to see correct data for first query but for second it says no data returned and check filter conditions
i don't have access to backed or admin too
So, I think we came to the conclusion that this problem is not OBIEE related. OBIEE generates correct SQL, which returns no data, right?
To solve this issue you need to analyse this SQL and data and find out why it returns no rows. You have the data and the query. It's a pretty easy task.
I can guess that "Start Date"."Start Date" has time part, but that's a guess. It's possible to play a hit and miss game the whole day.
it doesn't have time part which i have validated.
worst case is i have no idea who the backed team is and alsothe admins know.
i thought i'll raise a case with obiee
I am seeing that it only gets correct results if the value is top , i mean the top value. there is not even second value which is getting correct results
That is still a database issue. I can see only two possibilities:
1. You find an error in the query so we can try to figure out why OBIEE generates the wrong SQL.
2. You trying to understand why this query brings no data.