new Data warehouse for Retail Sales and snowflakes design

Posted on 2011-09-06
Medium Priority
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.

Question by:RamzyNEbeid
1 Comment
LVL 28

Accepted Solution

Ryan McCauley earned 2000 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:


Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

619 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