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
Subscribe to:
Post Comments (Atom)
-
In SQL Report Subscription, you may want to send the report with the link and you can do it by selecting Include Link value. But some time...
-
In SQL Server Analysis Services Cube, there may be a situation where we need to combine two related fact tables. This kind of a situation ma...
-
When I tried to connect to a SharePoint URL in dashboard designer options, it prompt a message saying "The URL is not available, does n...
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.
ReplyDeleteFor 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.