Calculated cell's performance -
11-21-2005
, 10:54 AM
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.
Why is there such time's difference?
thx |