Hi Steve,
I'd recommend the following whitepaper for you. The topic is covered in
depth.
http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp
--
Sean
--
Sean Boon
SQL Server BI Product Unit
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
<anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
Hi,
Can anyone please advise me on this
I have 5 Dimensions with 5--7 members. and a Fact table
of 1.5 million rows. Ideally what should be my storage
size i.e what should i set my performance boost (I will
be using MOLAP as my storage mode). Shall I use 50%
performance boost. (In this case am I missing data at
run time).
Thanks
Steve |