#SmartPivot for Excel–Now, for the new OLAP Features
March 29, 2012 2 Comments
In my last post I covered a brand new feature in this release of SmartPivot-pivot viewer visualization-, actually not olap related, as in you don’t need a cube, just a regular Excel table.
But SmartPivot still is, and will always be, a cube exploration accelerator for Excel. It makes things easier with features and quick-wins that are not available in Excel out-of-the-box (although they should honestly… and we actually have other things to do beside “fixing” Excel Olap browser usability issues… :) )
Anyway, we have a really hard time saying no to our users :)… when they ask, “well, you know… this pivot field list is always expanding, we have a hard time seeing the cube “big picture”… could you…well collapse it? toggle it?”… And well, so we have…
1) a Collapse/Expand Button for the pivot list fields! (this will work only on Excel 2010, sorry)
Select the Toggle Fields and toggle between expanded or collapsed fields:
2) you can search fields (measures, attributes, hierarchies), searching as you type – Excel 2007 & Excel 2010
it will do multi term search, just use a space to split the terms you’re looking
3) Filter by list of items, ex: Order Numbers – Excel 2007 & Excel 2010
Paste your items and apply the filter:
4) Detail a cell value in a new pivot with the Detail by feature-Excel 2007 & 2010
Select a cell value on the pivot you want to explore further, then select Detail value by:
That value will be isolated in a new pivot, you can immediately select another hierarchy to drill down/detail it. (The original pivot remains intact)
The new pivot is drill by the selected field. If appropriate a pie chart is automatically generated:
Off course you can start from this values into new Detail by actions, ex: detail Calgary.
5) Create a quick chart dashboard almost instantaneously – Excel 2007 & 2010
Just select Create Dashboard, if no pivot table is selected, you’ll be asked for an analysis services connection:
Select the fields you want on the filters zone (you can always change them later):
And the new dashboard is created for you, all pivot charts, pivot tables and filters properly connected. Just edit each chart for the view you want.
6) Quickly jump to a pivot chart data values (base pivot table), Just select a pivot chart and then Show Chart Data:
We can then explore the values, using the Detail By feature for example.
That’s it for today. Grab a copy and tell us what you think. Happy cube browsing!