Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting error: could not find level detailed enough for GROUP BY clause

784355Jan 11 2011 — edited Jan 12 2011
Hello,

Using obiee 11.1.1
I am getting this error message when trying to select one column from the subject area.
I am getting when i am selecting from Customer table any column(in the subject area).

No idea why this error is throwing

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14050] Internal Error: could not find level detailed enough for GROUP BY clause: [CUSTOMER.CUSTOM_TAG1, METRIC.DATE_ADDED]. (HY000)
SQL Issued: SELECT s_0, s_1, s_2 FROM ( SELECT 0 s_0, "subject_area_bm"."CUSTOMER"."CUSTOM_TAG1" s_1, "subject_area_bm"."METRIC"."DATE_ADDED" s_2 FROM "subject_area_bm" ) djm

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2011
Added on Jan 11 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
2,269 views