Writeback Performance -
05-24-2006
, 01:22 AM
Hi
We have a C# app connecting to local SSAS 2005 server. All works well except
when I do a single cell write back (all members are leaf nodes).
hers my MDX
"UPDATE [PL] SET
([Year].[Years].&[3],[Account].[Accounts].&[20],[Group].[Groups].&[33],[Scenario].[Scenarios].&[3],[Currency].[Currencies].&[3],[Measures].[Amount
- Fact P L],[Month].[Months].&[12],[Region].[Regions].&[12]) = 100"
The C# is written in VS2005, heres my code
cmdOlap.CommandText=sWriteMdx;
AdomdTransaction adoTrans=mcnADOMD.BeginTransaction();
cmdOlap.Execute();
adoTrans.Commit();
In our old 2003 project connecting to MSAS2000 it was a split second now it
takes about 5 - 6 seconds on the adoTrans.Commit
Any help would be appreciated |