How to count the dimension members - Using Factless fact?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » How to count the dimension members - Using...

How to count the dimension members - Using Factless fact?

Rate Topic

Display Mode

Topic Options

Author

Message

busysatish

Posted Thursday, November 05, 2009 12:00 PM

Forum 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 »

Permissions