May 28, 2015 at 8:18 am
I have a date dimension I'm struggling with. I have a hierarchy with Year, Quarter, Month, Date. The KeyColumns are Year(int), Month(int) for the month attribute and the Name column is MonthShortName(WChar). The type is set to "Months". When I use my hierarchy in Excel I see each month fall under each year. If i use ONLY the month attribute (not the hierarchy) I see 12 rows (not 12 rows per year), with all of the data across the years in 1 month row. This functions exactly as I would expect. With out the Year being used, it should roll up all the data into the respective month.
I have basically the exact same setup for week of year. KeyColums are Year(int), WeekofYear(int) and the NameColumn is WeekofYear(int). The type is set to "WeekOfYear". I have a hierarchy Year, Week of Year, Day of Week, Date. When I use the hierarchy it performs as expected, each year has 52 rows under it. However when I use just WeekOfYear attribute (not the hierarchy) I would expect to see only 52 rows... instead I see 52 rows times the number of years. Even though no Year attribute was used.
My attribute relationships are defined basically the way my hierarchies are setup and they are defined as Rigid.
I feel like these two should function basically the same way. Any thoughts here would be greatly appreciated. I've included some screenshots as well. Thanks for the help in advance
SSAS 2012
Enterprise Edition
Multidimensional Model
May 28, 2015 at 8:35 am
After a closer look, i see that the month is not working as expected. It's behaving like the week of year. So they both behave consistently, but not the way I want.
June 1, 2015 at 12:30 pm
You could do something similar to the following post maybe: http://www.sqlservercentral.com/Forums/Topic1668379-17-1.aspx#bm1668991
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply