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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Advice on where to find info about designing Cubes

Author  Topic 

LaurieCox

158 Posts

Posted - 2014-08-22 : 12:19:45
I know I can google for it but there is lot of stuff out there and it is hard to sort the good from the bad. Plus mostly what I am finding is a lot of stuff about the mechanics of using Visual Studio to create the cube for deployment. I pretty much know how to do that but what I need is where to get started in developing the fact tables and dimension tables.

My current knowledge is very limited. So far I have worked with a cube that was already designed and have only had to add some dimensions and calculated measures.

I have now been tasked with: Take this report and turn it into a Cube so we can do "stuff" with it.

I know I have to ask the user to define "stuff" a little bit better but I need more understanding of designing a cube before I can ask intelligent questions.

So can anybody recommend good sites where I can learn more about designing cubes?

Thanks,

Laurie

MichaelJSQL
Constraint Violating Yak Guru

252 Posts

Posted - 2014-08-22 : 12:42:53
Try the following

BIDN.com
or
http://www.pragmaticworks.com/LearningCenter/FreeTrainingWebinars.aspx
Or
http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/
Go to Top of Page

BBarn
Starting Member

14 Posts

Posted - 2014-08-25 : 10:47:26
Data Mining with Microsoft SQL Server 2008 - Wiley publication - ISBN: 978-0-470-27774-4

This book is a good reference for data mining which includes cubes (OLAP).
Go to Top of Page
   

- Advertisement -