Thursday, August 4, 2011

Two sets defined in the function have different dimensionality

When I tried to write a custom MDX query to retrieve Cube data, I got an Error message saying "Two sets defined in the function have different dimensionality".

The reason was we have to keep the same order of the Measures and Dimensions in the tuples, otherwise we will get the above error message

1 comment:

  1. Can you give example. Suppose we want to filter reords on basis of two dimension and a measure, and we take count of the records returned. when i use 1 dimensionand a measure it works else it fails.

    For eg. we want to see for how many weeks a product has not be sold.
    dimension will be week and product and measure will be product not sold.

    ReplyDelete