Could any expert of Microsoft Analysis service tell me what is the
storage and compression algorithm of the cube data file.
Thanks in advance.

Not sure what exactly you are asking about. The exact algorithms and data
structures are Microsoft IP, but you can get some high-level details from
the "Analysis Services 2000 Internals" presentation. You should be
particularly interested in slides 23 through 27.
Link to presentation is here:
http://sqljunkies.com/WebLog/mosha/a...1/27/5290.aspx

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"C.F" <cfzhang (AT) interactiveedge (DOT) com> wrote

Thank you very much for your reply.

My problem is to estimate the local cube file size when slicing from
the Microsoft Analysis Server cube before really creating the local
cube.

After investigating the local cube file structure, I have already
created some formulas to estimate the size of some streams such as
cubename.index,cubename.mdl and dimension.dim etc. in the local cube
file, but I cannot figure out the formula for cubename.data stream. If
there are some articles about the storage and compression algorithm
used by cubename.data stream, it will help me a lot to work out the
formula. So far, I use the formula 'Size = (
(2*levels*Cpath)+(4*measures4*Cdata4)+(8*measures8 *Cdata8))* number of
record', but the result is not accurate.

Does anyone have some suggestions about how to estimate the size of
local cube?

Thanks.




Mosha Pasumansky [MS] wrote: