Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculated member analysis services
Hi
If I shoot this off against an 2005 cube from excel 2007 it works: Sub UseCalculatedMember() Dim pvtTable As PivotTable Windows("test2000.xlsx").Activate Set pvtTable = Worksheets("Sheet2").Range("A1").PivotTable ' Add the calculated member. pvtTable.CalculatedMembers.Add Name:="[Measures].[test3]", Formula:="'[Measures].[Actual Unit Cost]'", Type:=xlCalculatedMeausure End Sub Howerver. If I try doin the same against a 2000 analysis services cube it fails with run-time error 1004 application-defined or object-define error I tried changing the formula to 1000 instead of certain calculated measure and then it works. Cant excel 2007 vba create calculated measure againt analysis services 2000 cube? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format of calculated member in VBA | Excel Programming | |||
SSAS Calculated Member in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated Members from analysis services | Excel Discussion (Misc queries) | |||
Excel Add-In for Analysis Services - What-If | Excel Programming | |||
PivotTableWizard using SQL Analysis Services | Excel Programming |