Query Error

i cant run the following query on the reporting(2005) surface . but it is perfectly running on the 2005 sql environment. can some one correct it?

select {[Date—VEPLock].[VEP Lock].members as status} on rows,

{[Measures].[Amount Usd]} on columns
from Profitability

where [Date—Fiscal].[Year].[2005].[Quarter 4].lastchild:[Date—Fiscal].[Year].[2006].[Quarter 4].lastchild

Error: measure hierarchi already appear in the axis 0.

Hello. You are using the MDX report designer in SSRS2005? If you enter your own MDX in the generic query designer you cannot use the graphical MDX report designer.

Another issue is that you cannot control where the dimensions will be placed on each axis with the graphical designer.

Third. If you use the generic query designer in SSRS2005 I still think you will have to make the MDX an expression

Code Snippet

="select {[Date—VEPLock].[VEP Lock].members as status} on rows,

{[Measures].[Amount Usd]} on columns
from Profitability

where [Date—Fiscal].[Year].[2005].[Quarter 4].lastchild:[Date—Fiscal].[Year].[2006].[Quarter 4].lastchild"

HTH

Thomas Ivarsson

|||I am using the MDX report designer in SSRS2005.