Hi all,
I deployed the "Adventure Works DW Standard Edition" cubes on my machine and I wrote the following simple MDX :
MDX 1
select
{[Measures].[Reseller Tax Amount]
} on columns,
{
([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany],
[Product].[Category].&[1])
} on rows
from
[Adventure Works]
The above MDX runs fine on my machine and gives me the output. The following version of SQL Server 2005 is installed on my machine : Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition
I tried running the same MDX on a server with the following configuration : Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Enterprise Edition . When I run this MDX I get the following error:
"The Tuple function expects a tuple expression for the argument. A tuple set expression was used."
I modified this MDX like this :
MDX 2
select
{[Measures].[Reseller Tax Amount]
} on columns,
{
([Geography].[Country].&[Australia]:[Geography].[Country].&[Germany] *
[Product].[Category].&[1])
} on rows
from
[Adventure Works]
The modified MDX runs fine on the server and gives the output.
To summarize, MDX 1 and MDX 2 both run fine on my local machine and give me the same output whereas on the server with a higher build of SQL Server 2005, MDX 2 runs fine while MDX 1 fails with the error - "The Tuple function expects a tuple expression for the argument. A tuple set expression was used."
I am unable to understand as to why this is happening Is this a compatibility issue which has been documented or is this a bug I request the community members to help me out.
Thanks in advance,
CodeKraker.