I am working with 30 lakh records and while creatimg
dimension ,get the following error:
Unable to count the members of 'XYZ' levle.Unable to
open recordset.Error:timeout expired.
I had then installed latest service pack (Sql2kasp1.exe)
The error was resovled but now when my database size has
increased upto 60 lakh records same error is comimg.