2 Replies Latest reply on May 9, 2016 2:15 PM by SriniVEERAVALLI

    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)

       

      new2.PNG

       

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

      new3.PNG

       

      It's displaying data at Day level.

       

      new5.PNG

       

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

      It's throwing odbc error.

      new1.PNG

       

      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.