How to count the dimension members - Using Factless fact?

• busysatish

  Grasshopper

  Points: 13

  More actions

  November 5, 2009 at 12:00 pm

  #385723

  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 ?