Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to count the dimension members - Using Factless fact? Expand / Collapse
Author
Message
Posted Thursday, November 05, 2009 12:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 03, 2010 10:01 PM
Points: 1, Visits: 31
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 -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 ?


Post #814474
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse