Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel 2010 Not showing Calculations created Expand / Collapse
Author
Message
Posted Friday, November 16, 2012 7:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 67, Visits: 345
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)


Post #1385708
Posted Tuesday, November 20, 2012 9:23 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Today @ 8:12 AM
Points: 67, Visits: 345
Sorry ID 10 T error.
I was still connecting to my backup database. Very very silly. I'll get my coat.
Post #1386998
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse