Click here to Skip to main content
13,006,221 members (66,519 online)
Rate this:
 
Please Sign up or sign in to vote.
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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170628.1 | Last Updated 18 Dec 2012
Copyright © CodeProject, 1999-2017
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