I have a Cube with 30 Dimension and it can grow to 75 or more.

Last night i tired to process the cube and in storage wizard it had
656 aggregation and 15% performance but It gave to error of tempdb is
full and tempdb grew from 8 MB to 25GB and I had just 25GB free space.

So I am not sure how much space is required for temdb to grow? Is
100GB or what?

If I need 100 GB space is there way to avoid it?

Thanks
Sameer

I guess the error message you received related to the tempdb in SQL Server.
Amount of space required by SQL Server's tempdb depends on the query and
type of indexes you have in your SQL server database.
Try running tuning advisor and see if you need to create indexes to support
type of queries Analysis Server is sending to SQL server during cube
processing.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights




<msam77 (AT) gmail (DOT) com> wrote