Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Adding Date Range Measure in calculated formula

Author  Topic  karbon Starting Member 9 Posts Posted - 2006-08-01 : 12:35:13 I am very confused I have DATE Dimension, and SalesAmount measures... When i use Analysis Manager Calculated Member Builder.. 1. If i choose DATE as <<Parent dimension>> and -------------------------------------------- aggregate(StrToMember("[Date].&[01/04/2005]"):StrToMember("[Date].&[31/12/2006]")) -------------------------------------------- I HAVE NO ERRORS 2. If i choose <<MEASURES>> as <<Parent dimension>> and ---------------------------------------------- (Measures.[SalesAmount] , (StrToMember("[Date].&[01/08/2006]")) ) ----------------------------------------------- as formula I HAVE NO ERRORS But i want to put DATE Range to the second formula. it gives error. My question is how can i add DATE range to the second formula. Maybe its very simple but i cant find any solution. thanks from now..