Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hierarchies in Tabular SSAS 2012 Expand / Collapse
Author
Message
Posted Wednesday, January 02, 2013 9:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 06, 2014 11:00 AM
Points: 121, Visits: 306
I created a tabular model of Adventure Works DW 2012. I created a Date Hierarchy in dimDate for Calendar Year -- Calendar Qtr -- English Month Name. When I do this in multi-dimensional SSAS, I know how to go in and establish the relationship so that the months are related to the correct quarter and year, etc... How do you do this in Tabular, though? I don't see advanced options for creating attribute relationships, sort order, etc... Once I build this model and explore it with PowerPivot, the month names are ordered alphabetically rather than numerically, etc.. ? Do I have to create a calculated column or something? I know I could use the MonthNumberOfYear instead, but is there a way to sort by that without displaying it in the hierarchy?Can anyone help me out?
Post #1401916
Posted Wednesday, January 02, 2013 9:57 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, April 06, 2014 11:00 AM
Points: 121, Visits: 306
I think I figured it out. In order to make your reports sort by the # of the month rather than alphabetically (so January comes before February), click on the English month name (BEFORE you create your hierarchy). In the properties pane, change “Sort By Column” to MonthNumberofYear.
Post #1401939
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse