This video shows steps you need to follow to:
1)Launch an Amazon EC2 instance
2)Install MS SQL Server, AnalysisEngine, and Visual Studio on EC2
3) Configure EC2 instance to allow remote database connection.

related video:
How to create Data Cube in Visual Studio? Data warehousing tutorial
https://www.youtube.com/watch?v=Umk53uCBGNs&t=419s