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.


Getting Error Description and Error Column Name in SSIS 2016...

If you check the Error Output Path of a SSIS Data Flow component, it only contains the ErrorCode and the ErrorColumn (actually this the I...