I have all the information regarding my OLAP database. I know how
many dimensions,hierchies, levels, members, and measures I will have.
I also will know the datatypes of the measures. Knowing all these
parameters, how do I calculate the number of bytes that my OLAP
database will use?

This is very difficult to do because of all of the compression which
Analysis Services uses.
What I typically do is to look at the source RDBMS without indexes -- then
Analysis Services data folder is then typically 1/4 to 1/6th of that size.
So, for example, if your source RDBMS is 400GB, then the data folder in
Analysis Services will probably be between 60GB and 100GB.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rico Cali" <ricocali (AT) hotmail (DOT) com> wrote

Dave,

Does your estimate include the aggregates?

Rico

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

yes
this include aggregations
but my "compression" ration is between 50% and 80% depending of the type of
measures and the number of aggregations.

"Rico Cali" <ricocali (AT) hotmail (DOT) com> a écrit dans le message de news:
675e1895.0409050704.3fe25a8b (AT) po...OT) google.com...

Yes, it does.
What you will find is that because of the 1/3 rule, large aggregations are
not created by Analysis Services. See the Analysis Services Performance
Guide
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rico Cali" <ricocali (AT) hotmail (DOT) com> wrote