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).