Hi All,

I have replaced the query in mdxquery.xml of sample application with
the following one.
When I run this query , it displays me "Subscript out of range".

But when I ran the query with single crossjoin on columns, it works
fine. Then modify the query by adding one more crossjoin with its
elements, it runs fine.What is the issue?

SELECT

NON EMPTY CROSSJOIN(CROSSJOIN(Descendants([BU_Site].[All
BU_Site],1,leaves),Descendants([Reps].[All
Reps],1,leaves)),Descendants([Location].[All Location],1,leaves)) ON
COLUMNS,

Non Empty {Crossjoin(Descendants([Business Unit].[All Business
Unit],1,leaves),{Measures.[ Calls],Measures.[Offers
Presented],Measures.[Offers Extended],Measures.[Offers
Accepted],Measures.[Yr 1 Spnd Pre Offers],Measures.[Yr 1 Spnd Ext
Offers],Measures.[Yr 1 Spnd Acc Offers],Measures.[CMV Pre
Offers],Measures.[CMV Ext Offers],Measures.[CMV Acc
Offers],Measures.[Total Cost Ext Offers],Measures.[Total Cost Acc
Offers],Measures.[Total Cost Dec Offers],Measures.[Incntv Pre
Offers],Measures.[Incntv Ext Offers],Measures.[Incntv Acc
Offers],Measures.[ Reps],Measures.[Total Cost]}),Crossjoin({[Business
Unit].[All Business Unit]},{Measures.[ Calls],Measures.[Offers
Presented],Measures.[Offers Extended],Measures.[Offers
Accepted],Measures.[Yr 1 Spnd Pre Offers],Measures.[Yr 1 Spnd Ext
Offers],Measures.[Yr 1 Spnd Acc Offers],Measures.[CMV Pre
Offers],Measures.[CMV Ext Offers],Measures.[CMV Acc
Offers],Measures.[Total Cost Ext Offers],Measures.[Total Cost Acc
Offers],Measures.[Total Cost Dec Offers],Measures.[Incntv Pre
Offers],Measures.[Incntv Ext Offers],Measures.[Incntv Acc
Offers],Measures.[ Reps],Measures.[Total Cost]})} ON ROWS

FROM [PSummary]

WHERE ([Time_Week].[All Time_Week].[2006].[10])