I have issues concerning calculated cell's performance.
If I create 12 calculated cells in a DTS, the retrieve takes 7 minutes
When I delete those 12 calculated cells and I recreate 12 calculated cells
with the calculated cells creation wizard on the same cube with the same MDX,
the retrieve takes 1 second.
XML of the DSOXml tool is the same in the 2 cases.

here my DTS code :
Dim sStatement
sStatement = "alter cube currentcube create CELL CALCULATION
CURRENTCUBE.[" & rst(4) & "] "
sStatement = sStatement & " FOR '(" & rst(5) & ")' "
sStatement = sStatement & " AS '" & rst(6) & "'"
Dim dsoCalcCommand
Set dsoCalcCommand = dsoCube.Commands.AddNew(rst(4))
if Err.Number <> 0 then
DTSGlobalVariables("gstrHISTORISATIONerror").Value = Err.Description
'-- Call WriteToLog(dirFile, Err.Description)
Exit Sub
End if
dsoCalcCommand.CommandType = cmdCreateCellCalculation
dsoCalcCommand.Description = "Calculated Cell generated by Script - For
Historisation"
dsoCalcCommand.Statement = sStatement


Why is there such time's difference?

thx

try posting this in sqlserver.olap newsgroup



"Seb" <Seb (AT) discussions (DOT) microsoft.com> wrote