Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
busysatish
Starting Member
2 Posts |
 Posted - 2009-11-05 : 14:01:26
|
| 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,StatusKeyIn the Dim_policy table I have the data as below -Policykey Paymentplan ......1 3-monthpayplan2 3-monthpayplan3 4-monthpayplan4 5-monthpayplan5 4-monthpayplanDim_paymentplan-1 -1 Unknown1 3 3-pay2 4 4-pay3 B 11-pay Monthly4 M 12-pay Monthly5 F Full PayNow 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 ? |
|
|
|
|
|
|
|
How to get count of dimension members ?