Descendants() function gives me the exact level in the Date hierarchy in SSMS
In MDX #14, I used this query to get the internet sales amount for each month.
The results above are from SSMS, and they are what I was expecting.
In SSRS, the same MDX query will give more than what the Descendants() function is asking
Run this same MDX query in the Query Designer in SSRS, this is what you will get.
We’ve noticed two differences.
- Unlike the results from the SSMS where the returns on the Y axis are not given any column names, all attributes from the Date dimension has a column name, and each column name is the same as the level name in the Calendar hierarchy.
- Unlike the results from the SSMS where only the Month is returned, the SSRS returned 3 more levels in the calendar hierarchy that are above the level Month.
Bad feature or good feature?
Having a column name is certainly a good thing in Reporting Services. But getting columns more than what I asked for can be annoying, although I can, on the other hand, also view it as a good feature, in case I need Year, Semester or Quarter for other purposes such as sorting.