I have an Analysis Services Cube that I would like to report on. However, the Time Dimension currently only has four columns, Day of Month, Month(name) , Year, and DateKey (DateTime representation at midnight for every day). Thus when I drag the month attribute onto the report, it is sorted April - August - December - etc. instead of Jan - Feb - Mar. How do I fix this? I remember reading something in the MSDN Library about it but I can't find it again now.
ThomasJust remove sorting for Time group in Report. It's well known problem.|||Hmm, I haven't added any sorting, this is just drag-and-drop from the list of dimensions in the "Report Builder" tool for Reporting Services and in Visual Studio. So I haven't added any sorting, however in VS I can modify the User Sort - Value property. Unfortunately if I remove it or set it to another field (my date key field) VS crashes when I try to preview. Any other suggestions?|||The Month attribute KeyColumns should be defined as a composite key consisting of the Year and Month column. This should get sorting right because if no Sort attribute is specified UDM will sort by the key. Take a look at how the Month attribute is defined in the AW sample cube.|||Thanks a bunch, but here's a funny story. I actually figured that out and was coming here to post the answer in case any one else needed it. Seems like you beat me to the punch. Thanks again anyways!
No comments:
Post a Comment