Thursday, March 08, 2012 4:13 PM
I am trying to make a custom group in the pivot table that is coming from the Analysis Services Cube (SQL Server 2008R2) in Excel 2010. If I create the group in the pivot table the items in the Pivot Table Field List become disorganized. What I have in the cube are measures that are put in their respective folders that are than visible in the Field List (both folders and measures). But when I create the group the measures and the folders are completely disorganized. Did anybody have a similar issue?
Tuesday, April 03, 2012 11:33 AM
Any thoughts on this? I found this but of no help since we are already using 2008R2 with the most current patches..
Do I need to open a Connect for this? Anybody???
Thursday, April 05, 2012 3:52 PM
I' using SQL Server 2008 R2 SP1 also and facing the
same problem as described at http://support.microsoft.com/kb/979777/
When the Excel user makes a new custom dimension Group
one folder of measures disappears from the PivotTable field List.
I’ m bypassing the problem by expanding making a new
Hierarchy but I can’t do this every time the problem appears and the KB 979777
does not apply to R2.
Wednesday, May 02, 2012 7:28 AM
Any updates on this for the 2008R2??? People need this and it's a pretty obvious bug!