Hi

I have an OLAP database (BAMAnalysis)....has 3 cubes and 17 shared dimensions. one of the dimension (AccountNo) is very heavy more than 10 Lac members ..... have placed a grouping level on top of it. But every night around 11:30 pm the OLAP process gets corrupt and keeps starting automatically but fails to load this AccountNo dimension...later after 45mins ~ 1 hr try, the OLAP process finally loads the dimension and then the system works fine for another 24 hrs.

Any idea why this happens EVERY night? and how to fix it up?

regards
yashrah.