Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
