• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

OLAP Cube Results from List

Shairal

New Member
Hello everyone,

I use an OLAP cube in Excel (2007 and 2010). Our Customers cube is an hierarchical cube - SalesDivision, SalesRegion, Customer - so to get to Customer I need to drill down through Division and Region first.
My question is, is there a way to use a look up list and have the cube return only those customers listed elsewhere on the worksheet? This would be a huge time-saver if I did not have to drill through multiple divisions/regions to pick out each customer that I need. Any suggestions would be appreciated!

Thanks!
Shairal
 
Kyle - Unfortunately you can't parameterize OLAP Pivots, as far as I know, so Mike's great trick won't work in this instance.

It would be possible to create a report using Excel's CUBE functions, but it might not be that dynamic.
 
Thanks guys for both your responses - great for getting me started in the right direction. I appreciate all the help!
 
shairal - I've been meaning to revise my 'Filter pivot based on external range' code to ensure it works with OLAP pivots for some time, so if that's what you want let me know, and I'll get a revised macro to you.
 
Back
Top