This is not a question that can be answered in a forum, you need to follow some examples or buy a book on datawarehouseing. SQLServerCentral.com
] is an excellent site for this research.
You need to decide on some strategies like how close to real time do I need to deliver the reports. Most OLAP systems aim for BD1 (business day + 1) and the cube creation is done overnight using an SSIS package.
Identifying your dimensions is very much a business specific issue, all FK fields for a start and then anything the user wants reported on.
We use SSRS but use the server version to deploy the reports, currently there is no Silverlight Viewer at a reasonable price. Our work around is to create the report in the WCF and deliver the PDF to the client, this onlyy requires a PDF viewer (telerik)
You don't MOVE your database you process your OLTP database into a OLAP database on a scheduled basis (overnight!).