So just expanding my thought process here, cause this will work. I would have to really increase the size of the fact table due to each dimensions requirement. Entity, account, accounting period, activity period, gross/net, hmn. I'll take this away and see what I can virtualize or normalize down.