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.;
In the Dim_policy table I have the data as below -
Policykey Paymentplan ......
-1 -1 Unknown
1 3 3-pay
2 4 4-pay
3 B 11-pay Monthly
4 M 12-pay Monthly
5 F Full 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 ?