I’m using the OLEDB Provider for Analysis Services 9.0 in Excel 2003 to get to my OLAP cubes in SQL Server 2005 Standard SP1.When I use Time as a Page filter in an Excel Pivot table, the dropdown looks like this (May_2006 is the default period):
-2006
-Qtr2_2006
+May_2006
+Apr_2006
+Jun_2006
+Qtr1_2006
+Qtr3_2006
+Qtr4_2006
+2004
+2005
I checked the field settings in Excel and it is using the data source order option.When I browse the dimension, the Time members are shown in chronological order.I’ve concluded that this behavior is a result of setting the default month in the Time dimension.Anyone know if this is simply the way it is when working with a defaulted Time dimension in Excel?
Moving to SQL Server Analysis Services forum.
No comments:
Post a Comment