Update cube stmt generated by "Extending OLAP with Excel" fails -
02-04-2004
, 01:47 PM
An Update cube statement generated by "Extending OLAP with
Excel" Excel 2003 spreadsheet fails with the error message:
"Syntax error in expression, near: "
Update cube [GLBUDGET_VIEW_BASED] set ([Measures].[Budget],
[Fiscal Year].[FY2004],[Business Unit].[All Business Unit],
[Dept].[cis].[All Dept],[Dept].[std].[All Dept],[Location].
[All Location],[VP_Group].[BudgetDetail].[All VP_Group],
[VP_Group].[BudgetReport].[All VP_Group],[VP_Group].
[BudgetReportLoc].[All VP_Group],[VP_Group].[TopLevel].
[All VP_Group],[Account].&[4050],[Type].[All Type],
[VP_Group].[budget].[All VP_Group].[Budget_Dept].
[Pharm_Sales_Group].[Inside_Sales],[Period].[All QTR].
[QTR1].[Apr])=-101 Use_Equal_allocation |