Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODBC error: Drilling at day level.

Received Response
1
Views
2
Comments
Chandra kanth
Chandra kanth Rank 3 - Community Apprentice
edited Aug 13, 2024 6:20PM in Oracle Analytics Cloud and Server

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.

Answers