Date dimension seems start from july...
-
Monday, January 28, 2013 1:13 PM
Hi everyone, I have a strange behaviour in my cube. I'm going to explain: I've the famous cube Analysys Tutorial, I deployed the cube, no problem, I went in date dimension, explore the hyerarchy , no problem, I can see Year--Month in the correct order. But..when I explore the cube in excel and I put the mont in the pivot table I have this situation:
Year 2007 Jan 2007, Febr 2007, March 2007...June 2007, July 2006, August 2006...December 2006.
Year 2008 Jan 2008, Febr 2008, March 2008...June 2008, July 2007, August 2007...December 2007.
from July to december the pivot show the former year...I can't understand why? I controlled the order in the attributes and it seems everything ok...Any suggestion?
All Replies
-
Monday, January 28, 2013 1:30 PM
Hello,
Which dimensions attributes / hierachies are you using, the "Calender" or "Fiscal"? The "Calendar" gives you the normal dates, while "Fiscal" represent a different business year, which differs from calendar year.
Olaf Helper
Blog Xing- Edited by Olaf HelperMicrosoft Community Contributor Monday, January 28, 2013 1:30 PM
-
Monday, January 28, 2013 2:09 PMI used both, in the second (Calendar) returns me just the year 2005 and 2006. I'm going over in the code but it's making me crazy. I'm trying to change the attribute key for the order...
-
Friday, February 01, 2013 8:30 AMModerator
Hi Diegoctn,
Have you solved this issue? Please take a look at the article below:
http://www.sqlchick.com/entries/2011/9/30/sorting-descending-in-analysis-services-for-a-date-dimension.htmlFor more information about Sorting Attribute Members Based on a Secondary Attribute, please see:
http://technet.microsoft.com/en-us/library/ms166763.aspxRegards,
Elvis Long
TechNet Community Support
- Edited by Elvis LongMicrosoft Contingent Staff, Moderator Friday, February 01, 2013 8:31 AM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Tuesday, February 05, 2013 2:00 AM
.png)
