Hi I am getting the following error for te below query. The Order Type Hirereachy is used more than Once in the cross Join Function. SELECT NON EMPTY { [Measures].[Order Qty], [Measures].[Order Value] } ON COLUMNS, NON EMPTY { ([Customer].[Customer].[Customer].ALLMEMBERS * [Order Date].[Order Type].ALLMEMBERS * [Order Date].[Order Type].members) I have create [Order Date].[Order Date] as two Parameters First Order Date and Second Order Date I am trying to create a MDX SSRS Report which gives the diffrence of order qty and order value between two dates. Any help or pointers to solution , material would be helpful. Thanks,

Hi sql fresher, I suggest you post your question on the Analysis Services forum , because it seems you are now facing a MDX issue rather than a Reporting Services issue. If you have any question regarding to reporting services, please feel free to ask. Thanks, Eileen