The Measures hierarchy already appears in the Axis0 axis

Viewed 69

I want to use the measures fields in both rows and columns in the MDX query and I have used the below query

SELECT{[Measures].[Average Rate]} ON COLUMNS, 
NONEMPTY(
  (
    TOPCOUNT(
      (
        Order(
          (
            ([Measures].[End of Day Rate])
          ), 
          [Measures].[Average Rate], 
          ASC
        )
      ), 
      201
    )
  ), 
  {[Measures].[End of Day Rate]}
) ON ROWS 
FROM 
  [Adventure Works] CELL PROPERTIES VALUE, 
  FORMATTED_VALUE, 
  FORMAT_STRING


but when am using getting the below error.

The Measures hierarchy already appears in the Axis0 axis.

Please share the steps to resolve the error.

0 Answers
Related