Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
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: 14025] No fact table exists at the requested level of detail:
This happens when you have one hierarchy but multiple dimensions. In such case leave the Fact table's Content > Logical Level as blank, otherwise the fact table will be restricted only to that specific hierarchy and will throw error by not recognizing the other dimensions details.
Hope it helped!
Hi Alex,
ReplyDeleteI am New to OBIEE. I am facing the same issue as you mentioned. Could you please help me where can I found the "Fact table's Content > Logical Level as blank" setting.
Regards,
Naren
Hi Naren,
ReplyDeleteGo to Fact table in BMM layer, expand Sources and double-click the Logical Table Source. The 3rd tab on top is "Content."
Make sure the "Aggregation content, group by" is set to "Logical Level."
Hope this helped!
Hi,
ReplyDeleteI am facing this same error at the time of scheduling my report. The regular analysis works properly. Can you help in understnading this issue.
Regards,
Nyren