Count active subscriptions problem RRS feed

  • Question

  • I need to be able to report on the number of active subscriptions at a specified time given a start date and an end date.  Is there a way to model this in SSAS?  I understand this is very similar to the classic inventory management problem.

    John Schroeder

    Tuesday, February 21, 2012 5:38 PM


  • You question is pretty generic, so a generic answer would be yes. You can count active subscriptions between 2 dates as long as the design supports it. You would need dimenions like status, time etc. In your fact table you would need to have 2 dates, status key, and a count measure.


    • Marked as answer by Challen Fu Monday, March 5, 2012 10:02 AM
    Tuesday, February 21, 2012 5:45 PM