ODBC error: Drilling at day level.

Chandra kanth

Hi All,

I am facing an error while drilling at day level. RPD have the following time dimension. The following is the drill path

Gregorian Quarter (varchar) -> Gregorian Month Start Date  (TimeStamp)  -> Day (TimeStamp)

When i clink on month start date (i.e 1/10/2016) it's displaying data.

Below screen shot is for month start date link (1/10/2016).

It's displaying data at Day level.

But when i clink on for the month start date 1/11/2016 (see the above screen shot)

It's throwing odbc error.

I am unable to trace the problem. Please advice me how to get it solved. When i drill down from month to day it's taking long time to display data, how to improve performance of this report.

Regards,

Chandra kanth.

Chandra kanth

Hi experts,

Please suggest me the possible solution for this one.

Regards,

Chandra kanth.

SriniVEERAVALLI

I would check NULL values for that date column.