Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to do it (2 fact table in 1 analyze)
Hi
I have 2 fact tables in RPD (payments_operation_f; cash_operation_f).
Fact tables connect on fisical and business layer with one dimension table (client_d). And now i want in one analyze get for client count operations: -count payment operation -count cash operation
| client_NAME (from client_d) | count(payment_operation)- from payments_operation_f | count(cash_operation)- from cash_operation_f |
|---|---|---|
| client_1 | 1 | 2 |
| client_2 | 3 | 4 |
In fact table i put count formula for both (payments_operation_f; cash_operation_f)
But when i move measures in analyze i get count(cash_operation) - NULL
And i see no sql to DB for cash_operations.
What i have to do for get correct result?
Thanks a lot!
Answers
-
Hi,
to get the answer you want then both fact tables need to share (have conformed) dimensions for all of the dimensions that you use in the analysis.
If there is a missing link between any fact to dimension (logical and physical), or its content level is not sufficiently granular for the request you are trying to run, then you will not get any data.
0 -
See this recent post on a similar theme; -
0 -
@Daan Bakboord - DaAnalytics - wrote this blog a while ago which really describes how to model the business model to enable this type of capability.
0
