Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2010-01-04 : 04:53:58
|
| Hi All.We are currently working on OLTP database and some reports(SSRS) are running on this database.We are planning to implement Reports from Cubes for some Past data analysis.I am very new to SSAS but not SQL Server and SSRS.How can i design/create a new SSAS/OLAP database based on existing OLTP database or from scratch.How to convert my existing tables into Dimension and Fact tables.If possible please provide some sample design documents.Please guide me.TIA. |
|
|
learntsql
524 Posts |
Posted - 2010-01-06 : 06:20:07
|
| Guru's any help/guidence.please........ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-06 : 06:32:04
|
quote:
Originally posted by learntsql
Hi All.We are currently working on OLTP database and some reports(SSRS) are running on this database.We are planning to implement Reports from Cubes for some Past data analysis.I am very new to SSAS but not SQL Server and SSRS.How can i design/create a new SSAS/OLAP database based on existing OLTP database or from scratch.How to convert my existing tables into Dimension and Fact tables.If possible please provide some sample design documents.Please guide me.TIA.
seehttp://www.exforsys.com/tutorials/msas/designing-the-dimensional-model-and-preparing-the-data-for-olap.html |
|
|
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2010-01-06 : 12:42:09
|
| Also use SSAS if you roll-up \ group data to a higer level, if most of your reports are at lowest granuarity then its good to design a dimensional model and use tsql to report from it.-Shan |
|
|
|
learntsql
524 Posts |
Posted - 2010-01-06 : 23:47:07
|
| Thank you very much. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-07 : 00:54:16
|
welcome  |
|
|
|
learntsql
524 Posts |
Posted - 2010-01-13 : 03:27:26
|
| Visakh I am working on OLAP databse design from existing OLTP database.I am get confusing how to map regular table of OLTP into dimensions and Fact tables and how to load the data into OLAP.Is there any links which shows this kind of sch.please.... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 03:58:42
|
quote:
Originally posted by learntsql
Visakh I am working on OLAP databse design from existing OLTP database.I am get confusing how to map regular table of OLTP into dimensions and Fact tables and how to load the data into OLAP.Is there any links which shows this kind of sch.please....
mostly the measures that you want to analyse in OLAP goes into fact tables and dimensions involve the data by means of which you're interested in analysis of measuresfor example, in case of sales analysis, measures can be sales qty,total sales amount,ytd figures etc while dimensions can be like product category,year-month-day(date),customer, etc. so former will go into facts and latter to dimensions. In OLAP since we are trying to optimise the retrieval, we keep tables in denormalised form. So logic that loads the olap tables actually retrieves related data from OLTP table(s) and loads them into dimension/facts after cleansing and applying transformations if any.also see belowhttp://www.information-management.com/infodirect/20041008/1011670-1.html?pg=1 |
|
|
|
|
|
|
New Analysis Server Database Design Help