AS Configuration

Hi

I try to run the following statement in “Server A” and it works fine then I make a copy of my cube (with backup & restore) in “Server B” and the MDX statement does not work.

My statement:

With

member [Measures].[Acum_Amount] as

'sum(

( YTD([Time].[Time].CurrentMember)

, [Scenario].[Scenario].&[PLAN])

, [Measures].[ Amount]

)/1000'

Select [Measures].[Acum_Amount] on 0

, [Time]. [Time].[Year].&[2005E3].&[Q1/ 2005].&[2/ 2005]

From [FT_BAB]

If I remove the code in red, it works in both servers. But it is not what i want.

What is wrong with the server configuration?

The SUM() function takes a set as its first argument and you are passing a tuple.

Sum( Set_Expression [ , Numeric_Expression ] )

I think what you are looking for on both servers is the following:

With

member [Measures].[Acum_Amount] as

'sum(

YTD([Time].[Time].CurrentMember),

([Scenario].[Scenario].&[PLAN], [Measures].[ Amount])

)/1000'

|||

You are right. Your syntax works in both of the servers. I will replace it.

I was confused because the other syntax works in one of the servers.

Thanks!!!!!!!!!!!!!!