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

Right, I was thinking this is the right direction, but I'm curious how I'd handle the per day items. Thinking of Volumes Per Day, you could have:

• T

Power Query and any connector using M has the ability to connect to and import data from an SSAS db. SSIS 2017 should have the ability to add a connector...