Excel 2010 Not showing Calculations created

  • Hi

    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)

  • Sorry ID 10 T error.

    I was still connecting to my backup database. Very very silly. I'll get my coat.

Viewing 2 posts - 1 through 1 (of 1 total)

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