Post reply

Show details cannot be executed when multiple items are selected in report filter

  • November 13, 2012 at 9:18 am

    #144041

    Hi All,

    I am building an XL based report. This report connects to an SSAS 2008 cube. When I pivot the data in excel and select multiple filter values in the pivot table, I get the following error.

    "Show details cannot be executed when multiple items are selected in report filter"

    Can anyone tell me if there is a work around for this issue?

    I am using XL 2010 and SSAS 2008 R2.

    Thank you,

    Ashok Jebaraj

  • November 13, 2012 at 11:32 am

    #1558588

    pivot table definitely should work with multiple reporting filter..

    are you referring to drill through?? basically when you are double clicking the data to get the detailed data behind it, while having multiple filters selected in the report filter?

    this is a known limitation in excel.. you either select just 1 item on the report filter.. or just select all.

    though theoretically.. you shouldn't need to do drill through all the time in cube..

  • November 13, 2012 at 1:40 pm

    #1558638

    Thank you for your response.

    Yes. I am referring to Drill Through. The spreas sheet will be hosted in a sharepoint. This spreadsheet will be used by different business groups. So customers will use the "Business Group" hierarchy (big hierarchy - 2800 values), the way they need. So they may select the values (multiple filters) in a hierarchy based on their need. Everyone who wants to analyse data would finally get into the details and see the set that contributes to the problem. If this is a known limitation...then I think I may have to choose a different approach.

    Is this an excel limitation or SSAS limitation?

    Thank you,

    Ashok Jebaraj

  • November 13, 2012 at 3:10 pm

    #1558679

    i think it's a more a ssas limitation.. on how the mdx is structured...

    so a user can belong to multiple business group?? if he/she select only one.. then there's no problem..

    i still don't understand why you need drill through for what you are trying to do though... if what you are trying to expose is numeric in nature. you can always include it in the cube.. so you basically just return the result as a measure...

    if it's a descriptive item or invoice number / etc... then maybe another approach is to have the cube to do all the high level reporting.. and a separate SSRS report (that points to the table itself) to do the detailed reporting

    just an idea

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply