Processing Cube hangs

hi,

i have problem processing cube. fact table (with telephone data) contains 400,000 records... increasing rapidly (400,000 records 8 months of data)...
i have few dimensions:
dimension user: 200 records
dimension line: 200 records
dimension direction: 4 records
dimension date: 365 records each year
dimension timeinterval: 24 intervals

so far good... when process dimension have no problem....
however, when add dimension (callednumber, 101 records) processing hangs starts...

the sql performed when processing cube looks this:
[code]
select field1, field2,... fieldn
from table1, table2,.... tablem
where
(table1.id=table2.table1id)
and
(table2.id=table3.table2id)
...
[/code]

when execute above sql in query analyser sql server enterprise manager, hangs...

i not suprised that, because sql first create huge table of 400,000 x 200 x 200 x 4 x 365 x 24 x 101 records , after works through statements filter out appropriate records.

for me more logical use following code process cube, cannot changed in analysis manager:
[code]
select field1, field2,... fieldn
from table1
left join table2 on (table1.id=table2.table1id)
....
left join tablem on (tablem.id = tablem-1.tablemid)
[/code]

when execute above sql in query analyser sql servel enterprise manager, not hang, performs query in 35 seconds....
but analysis manager not allow me change sql used processing cube...

what can add more dimensions cube... (it more anyway after adding callednumber dimension)??
any suggestions?

ps. forgot mention: use sql server 2000

for people have same problem... on forum got answer (thanks darren gosbell) gave me solution:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agoptimizing_1qr7.asp

SQL Server  >  SQL Server Analysis Services