Office 2010: Excel 2010 – New Buttons on Ribbon for Pivot Tables – Custom Named Sets!
Jul.16, 2009 in
Business Intelligence, SQLServerPedia Syndication
Just this week I blogged about adding Named Sets in VBA. Well lo and behold, in Excel 2010, there is a button “Fields, Items, & Sets” that lets you define your own Named Sets. Either with MDX or based on rows/columns you have on your pivot table
Works pretty slick! There goes the need for the custom VBA solution, which is fine by me. Although I am disappointed you still can’t create your own calculated measures. The OLAP Pivot Table Extensions add-in lets you, so I wonder why the built in functionality still doesn’t let you.
Simlar Posts
- Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
- OLAP PivotTable Extensions on CodePlex
- SSAS 2005 – Named Sets – TopCount – Static/Dynamic and Ordering
- SSAS: Create a Calculated Measure always getting the value for “Yesterday”
- SSAS: AverageOfChildern and Semi-additive measure requires a time dimension
July 17th, 2009 at 2:45 pm
[...] BI wpc round up for microsoft bi Office 2010: Excel 2010 – New Buttons on Ribbon for Pivot Tables – Custom Named Sets! What’s new for Analysis Services users in Excel 2010? First impression of Excel [...]