nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Issue while filtering date in OBIEE

3244578

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?

Find more posts tagged with

Accepted answers

All comments

Andrew Fomin.

Have you looked at the SQL this report generates for both cases? Typically it allows to understand what is going on instead of guessing.

3244578

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')

Andrew Fomin.

OK. And what happens when you execute these queries?

3244578

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

Andrew Fomin.

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.

3244578

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

3244578

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

Andrew Fomin.

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.