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).
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...