How to Create an OLAP Cube from an SQL View?
There are a few ways of creating an OLAP Cube for MS Analysis Services. You can create an OLAP Cube by following the steps defined in the wizard. You should first select your fact table and then add dimension tables in this wizards.
The wizard may be a little bit confusing for some cases. So why bother it? Just define a fact table then select your dimensions and measures within this fact table.
If the data you need for your analysis is distributed among a number of tables, you can create a view to gather the necessary information from these tables.
After adding this view as a fact table, you can select and insert the desired columns of this sql view as dimensions and measures.