Oracle Analytics Cloud and Server

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

Is possible to jon aggregate fact table to a fact table

Received Response
1
Views
2
Comments
ForSly
ForSly Rank 5 - Community Champion

I have an aggregate fact table that I wanted to join to the main fact table but I am not sure how that would work. They are both at the same level of details.

Answers

  • ForSly wrote:an aggregate fact table .... They are both at the same level of details. 

    How is that even possible? An aggregated table, at least in OBIEE wording, is generally a fact table having less data by being at a less detailed level for one or many dimensions.

    Just like the other thread: you really have to post more details about the context to get some useful feedback, otherwise it can only be random theories which probably never match your question or use case.

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

    +1 to Gianni. Needs a lot more detail:

    Never underestimate how effective a small diagram is. ERD's have been invented for a reason.