Hi all...I have a reporting challenge, and I am wondering what the best way to handle this in a cube is.
I have essentially two fact tables.
I have an account event type table that looks something like this:
The account Referral table:
Date Acct Status Balance TreatedDt
1/1/08 123 Good $123.45 2/10/08
1/1/08 124 Bad $654.45 1/10/08
2/3/08 123 Bad $128.45 Null
The account history table:
Date Acct Balance Status
12/1/07 123 $123.45 Delinquent
1/1/08 123 $128.45 Delinquent
2/1/08 123 $138.00 Charged off
12/1/07 124 $654.45 Delinquent
1/1/08 124 $660.03 Current
2/1/08 124 $660.03 Current
What is the best way to integrate the event type data and the account type data in a cube so I can display vintage account performance data. I have looked into semi-additive measures and other types of solutions (including duplicating the event data for each of the account history months), but I haven't found a good solution. What is the best practice here?
Thanks,
Dan
I have essentially two fact tables.
I have an account event type table that looks something like this:
The account Referral table:
Date Acct Status Balance TreatedDt
1/1/08 123 Good $123.45 2/10/08
1/1/08 124 Bad $654.45 1/10/08
2/3/08 123 Bad $128.45 Null
The account history table:
Date Acct Balance Status
12/1/07 123 $123.45 Delinquent
1/1/08 123 $128.45 Delinquent
2/1/08 123 $138.00 Charged off
12/1/07 124 $654.45 Delinquent
1/1/08 124 $660.03 Current
2/1/08 124 $660.03 Current
What is the best way to integrate the event type data and the account type data in a cube so I can display vintage account performance data. I have looked into semi-additive measures and other types of solutions (including duplicating the event data for each of the account history months), but I haven't found a good solution. What is the best practice here?
Thanks,
Dan