I have to olap cubes: 1 for insurance policy information and the other for
payments. The policy fact table has one record for each policy (premium,
commission) and related dimensions (Ins.co, renewal date, etc...)

The payment fact table contains a record for each payment made on that
policy (in the event of payment plans). I can join the 2 fact tables on the
surrogate key in QA.

What I need to do is join the 2 cubes so that we can view Policy info on the
rows and time to payment on the columns (for example).

Is this an appropriate use for a virtual cube, or is there a better solution?

Thanks in advance!

If their grains are different or their fact dimensionalities are different,
using virtual cube is useful. In this case, more shared dimensions are used
commonly, more meaningfully you can do analyze it.

Ohjoo Kwon


"Sean" <Sean (AT) discussions (DOT) microsoft.com> wrote