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.
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.
+1 to Gianni. Needs a lot more detail:
Never underestimate how effective a small diagram is. ERD's have been invented for a reason.
