Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Bug: wrong data from OLAP source

Incorrect values of dimension in pivot table sourced on OLAP cube (Microsoft SSAS 11.0.5569.0). The latest version without that bug is 16.0.6001.1068. Obviously we don’t know exact source of this bug, but most of the issues we discovered were on complex pivot tables with many attributes, partially displayed dimension’s hierarchy and without subtotals. Example of this bug occurring is in attached file ExcelBug. There are 2 exactly the same pivot tables (the table on the right hand side is basically copy of the table on the left hand side). After removing “Grand Total” on the table on the right hand side some fields have incorrect data displayed.
In this example field B4 contains correct value: „5 Name” (coloured green), field G4 (after removing grand total) contains wrong value: „6 Name” (coloured red).
Video https://youtu.be/RRwfAQVGBfc shows steps to change data source of pivot table and the bug itself. Files ExcelBugSSAS.abf and ExcelBugDBMSSQL.bak are backups of SSAS cube and database with all metadata and data to recreate this scenario in any environment (with SQL Server 2012).

16 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base