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.
| Author |
Topic |
|
walidwalid
Starting Member
12 Posts |
 Posted - 2008-10-08 : 11:29:06
|
| i have a measure called [Una YTD Act] and dimension called CC_2006 this dimension has about 250 members.I want ot calculate the sum of [Una YTD Act] to two members only called [CC_2006].[Building] and [CC_2006].[Parts]I have wrote this MDX but it returned Error : with member [Measures].[M1] as [Measures].[Una YTD Act] - { [CC_2006].[Building] , [CC_2006].[Parts] }select [Measures].[M1] on 0from cube1where [Calendar_Date].[Year - Quarter - Month - Date].[Year].&[2008-01-01T00:00:00]Please Reply.Thanks for all.W.Y. |
|
|
|
|
|
Question in MDX