I am using a Multi-Cube to tie two data providers together.
DP1 has Acct # and Event
DP2 has Acct # and Revenue
I want to build a table that has Event and Revenue. The problem is that a single account can be associated with multiple events. The Multi-Cube only counts the Revenue once; I actually want the total of my event table to be GREATER than the total of the Revenue in DP2. In other words, if an account has attended two events, I want the revenue of that account to count for both events.
Weird, I know, but that is the requirement. Any ideas?
Thanks!!!
jdean1012 
(BOB member since 2007-06-26)