I hope someone can help me. I have a cube that contains several calculations, these are created in the Measures, some in a parent folder others not.
I've processed the cube and I can use my calculations happily when I browse the cube in BIDS.
However when I try to use the Analysis Server as the source of my Excel 2010 Pivot Table I can't see the calculations.
In the properties of the Pivot Table "Show calculated members from the OLAP server" is ticked.
I've read there was a problem in Excel 2007 but nothing about 2010 having the same issue.
SQL Server 2008 R2 SP1 Developer Edition (32bit)
Windows 7 (32bit)
Excel 2010 Professional (32bit)