Click here to Skip to main content
11,567,325 members (45,193 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL SQL-Server Silverlight , +
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 15-Dec-12 17:30pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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!).
  Permalink  

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

  Print Answers RSS


Advertise | Privacy | Mobile
Web04 | 2.8.150624.2 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100