Hi its a multi dimensional cube SSAS is version 11.0.3412.0. I'm not sure I can export the data because I don't have access & it's pretty sensitive.
I carried out a few tests & discovered something odd in Excel. I started a new Workbook & connected to the Cube to start a new pivot table within the pivot table options there is option 'Evaluate calculated members from OLAP server in filters' I have
no idea what it does but when I uncheck this & refresh the pivot table it seems to maintain the setup & the data is still there only thing is I don't know if it's refreshing properly & calculating the Measure.
This is what I see in the pivot table options when I start a new Workbook & create the pivot table from scratch.
New Pivot Tables
The unfortunate thing is I have already created a lot of files with a lot of pivot tables using a Calculated Measure when I look at the pivot table options in that I see something different
Existing Pivot Tables
I think this may be causing the issue but I am not entirely sure. Both files were created in Excel 2013 so I can't see why one would have the 'Evaluate calculated members from OLAP server in filters' option & the other would not. The Measure I have created
is nothing overly complicated either.
So has anyone seen this before or experienced anything like this? & does anyone know what the 'Evaluate calculated members from OLAP server in filters' as I can't find anything on this.