MDX query

• got2bebored

  Newbie

  Points: 9

  More actions

  January 6, 2011 at 7:10 am

  #243234

  Hello,

  I am Trying to make a calculation where I calculate the current number of members

  I have a cube with the following

  fact table with

  membershipid --- joindate --- leavedate (if any)

  When browsing my cube the idea is that i can see and drill down to the amount of members at a given year,month,date.

  so The leavers have to be substracted from the members but on the right date.

  Hope you understand what I intend to do here

• amit_gupta01

  SSChasing Mays

  Points: 605

  More actions

  January 12, 2011 at 5:26 am

  #1272300

  Please elaborate your issue with example.

  Thanks,
  Amit G
  http://www.msbiconcepts.com