November 5, 2009 at 12:00 pm
I m using a factless fact table fact_paymentplan and the structure is as below. I have different dimensions policy, date, paymentplan, productline, region, property etc.;
fact_paymentplan
=============
PolicyKey,
EffectiveDateKey,
ExpirationDateKey,
paymentplankey,
ProductLinekey,
regionkey,
propertykey,
TransactionEffectiveDateKey,
StatusKey
In the Dim_policy table I have the data as below -
Policykey Paymentplan ......
1 3-monthpayplan
2 3-monthpayplan
3 4-monthpayplan
4 5-monthpayplan
5 4-monthpayplan
Dim_paymentplan
-1-1Unknown
133-pay
244-pay
3B11-pay Monthly
4M12-pay Monthly
5FFull Pay
Now I wanted to get the count of number of payment plans by state, company, product and payplan...
For this reason, I designed a factless fact and try to get the count...Already I have a cube with other fact tables and dimension tables existing..Now based on the requirement to get the count of paymentplans, I got to design this additional factless fact and the Dim_paymentplan dimension. Please advice on how to do this in Analysis services ?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply