Click here to Skip to main content
15,867,954 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

Problem statement :

I have a relational database which consists of many tables approx(100). I want to move it into Analytical database. How can this be achieved.

1- What are the steps that i need to take?
2-How to identify the dimensions and measures for cubes?
3-How to move my data from relational database to analytical database?
4-Currently i use SSRS to prepare reports. I want to use it with silverlight for good GUI. Is it possible?
5-I want to move my relational database to analytical database for faster query execution which i want to use with reports. Is this possible or there is some other better alternative?
Posted

1 solution

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!).
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900