Heres the scenario:
I have two cubes joined in one virtual cube, one with 'contract' toher with
'payments'.
[Time].[Calendar] is present in all cubes. I also added dimension
[Contract].[Key] in all cubes. It basically has unique key of each contract.
Now, I have two measures, one from each cube. ContractValue and
PaymentValue. Both of them change over time. The problem I have is with
PaymentValue, since I must only use PaymentValues that are on the contracts
in the query. However, [Contract].[Key] does not have to be in the query.
Usually query would be something like 'give me ContractValue and payments
for partner xy for contracts signed in year 2004'.

Anything I came up with is extremely slow (10+ minutes for a couple of
contracts). Any ideas?


MC