My cube is based on Active Directory data. Currently, the cube shows the users listed by region and country (Region:Country:User), with a measure based on the number of users. The cube can be sliced by the date that the user account was created.
The problem with this is that if you select anything but ALL dates, the measure shows only the number of users created within the selected date range. I want to add a calculated measure that will give the the total number of users that existed up until and including that create date, rather than just the create date itself.
Any suggestions on the MDX I would use to create the calculated measure?
The problem with this is that if you select anything but ALL dates, the measure shows only the number of users created within the selected date range. I want to add a calculated measure that will give the the total number of users that existed up until and including that create date, rather than just the create date itself.
Any suggestions on the MDX I would use to create the calculated measure?