Solved

new Data warehouse for Retail Sales and snowflakes design

Posted on 2011-09-06
1
476 Views
Last Modified: 2016-02-14
Dear all
I will start to create my first data warehouse.
All my work will be with SQL Server 2008 R2, SSIS, SSAS, SSRS

I will start by Retail Sales, I did read the part of retail sales from “The Data Warehouse
Toolkit Second Edition the Complete Guide to Dimensional Modeling” for Ralph Kimball

So far the data warehouse structure is clear for me but there are some points I want to clarify.

What is the advantage and disadvantage of the snowflakes? (Example Product and Sub category and the Category) if I didn’t use the snowflake how will I show this data later in the cube.

thanks,
0
Comment
Question by:RamzyNEbeid
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 500 total points
ID: 36496289
It just changes how your fact data rolls up in SSAS - when you're building your SSAS project, you can define dimension hierarchies, but some of them will be defined for you if you're using a snowflake layout because Visual Studio will see how the data is supposed to roll up based on your dimensions.

Here's a Technet chapter talking about dimension granularity and how to create rollups, which a snowflake layout makes a little easier:

http://technet.microsoft.com/en-us/library/ms166573.aspx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now