This process is doable, although you may want to explore some design information on the web from the two many design patterns: Kimball is one and Inmon is the other.

Specifically, you can have multiple fact tables in a single cube and you can have "fact" dimensions, although I have found such a setup is not very performant. You may want to explore moving the data into some data warehouse tables which more closely match you desired end results.