Hi Dave:

Actually General Ledger Transaction is a fact table but I added it as a dimension as they want to drill down for transaction details (i.e. transaction number, description etc).

What...

Thanks. I tried to process it on 64 bit machine. The dimension itself took more than 2 hours to process but it ran sucessfully.

I am having the same problem. I have a dimesnion "General Ledger Transaction" that has around 30 million rows and it will drow over time. When I process the dimesnion...