use olap named sets as filters in excel 2007 pivot table report RRS feed

  • Question

  • Hi eb

    This is a general pivot table question (relevant to excel 2007).

    I want to use SSAS named sets as pivot tables filters in a report using classic olap (multi dimensional) as data source.

    Excel is blocking this option....

    Any work around preferably suitable for non developers simple users??



    Wednesday, May 28, 2014 8:32 AM


  • Hey thanks very much for asking!

    but after much investigation it seems like an unsupported feature in Excel

    (same goes for excel 2013...).

    Would appriciate any workarounds should they exist...

    Thanks again!


    Monday, June 30, 2014 2:14 PM
  • I can't find anything. Please use the Smile/Frown Feedback button in the UI to request the feature.


    Ed Price, Azure & Power BI Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Friday, July 11, 2014 8:59 PM

All replies