Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dates in calculated measure
I wasn't planning to reply to my own posting, but here is the solution that I've come up with in the calculated measure: Sum(PeriodsToDate([DateCreated].[(All)]), [Measures].[Accounts created]) This appears to be providing me with the desired results, but if someone sees a problem with...- rhs55
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Dates in calculated measure
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...- rhs55
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
