Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Issue while filtering date in OBIEE
Hi All,
Facing a weird issue in OBIEE.
I have a date column with values in it.
If i try to add a filter to the date for some value (i select the date through calendar) then the report results no values even though we have values for it.
I tried to convert the date again using cast operator but still the issue remains same.
Also, another weird issue is for some values it's working (i have tried for 2 so far where i am getting values)
Can anyone help in identifying what might be the issue?
Answers
-
Have you looked at the SQL this report generates for both cases? Typically it allows to understand what is going on instead of guessing.
0 -
Hi Andrew,
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
WHERE
(cast("Start Date"."Start Date" as date) = date '2006-08-01')
WHERE
(cast("Start Date"."Start Date"as date) = date '2009-05-15')
0 -
OK. And what happens when you execute these queries?
0 -
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
0 -
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.
0 -
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 obiee0 -
Hi Andrew,
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
0 -
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.
0