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

Alex Sharkov

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!

Robert Angel

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.

Robert Angel

See this recent post on a similar theme; -

Fact is not showing data Against the Dimension..

Joel

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