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

Report with fields from Multiple Fact Tables

Received Response
3
Views
4
Comments
Adi Md
Adi Md Rank 2 - Community Beginner
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi Team,

I have a requirement where I need to create a report from 3 different fact tables.

All the 3 tables have same dimension conforming.

They work independently without any issue.

But when I combine fields from different fact tables together then I am getting error -

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: 14025] No fact table exists at the requested level of detail

Can someone help me on this?
Its the same dimensions and still this is not working.
Do I need to create join between 2 fact tables as well?
The only issue is that not both table have data for every combination of dimensions. For example: - I have got tables CUTSOMER SHIPMENTS and CUSTOMER ORDERS.
Now during given week not every Customer - Item combination will have both orders and shipments.
Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Did you correctly set the content levels in your business model?

    Because the error you have means your didn't provide OBIEE enough info to know how to manage the conformed dimensions to mix together the values from your multiple fact tables.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 to Gianni. It's all in the content levels

  • Adi Md
    Adi Md Rank 2 - Community Beginner

    I did !!!

    I even tried changing from Logical Level to Columns and still have same issue.

    I guess the issue is due to some details cannot be aggregated.

    For example: - In CUSTOMER_SHIPMENTS table the column 'WAYBILL' is VARCHAR that stores a text. Now this cannot be aggregated, right?

    Can you confirm if this is the issue and resolution if any?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Are you saying in your fact tables you have attributes without aggregation rule on them?

    Well ... of course that can't work.

    A text isn't a measure and has nothing to do in a fact table.

    Look at degenerated dimensions, it's how to correctly model attributes coming from the physical table being the source for a fact table.