How to do it (2 fact table in 1 analyze)

Question

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_fcount(cash_operation)- from cash_operation_fclient_112client_234

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!

Joel Acha · Answer

@Daan Bakboord - DaAnalytics - wrote this blog a while ago which really describes how to model the business model to enable this type of capability.

Robert Angel · Answer

See this recent post on a similar theme; -

Fact is not showing data Against the Dimension..

Robert Angel · Answer

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.