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.


How the transformed data is written to an output file with column headers in U-SQL...

While working with U-SQL language, I noticed that there are few ways of writing data to an output file. Let's assume the SalesDetails....