Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Solved
new Data warehouse for Retail Sales and snowflakes design
Posted on 2011-09-06
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,
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,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss. This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in. And this behavior is only see…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month7 days, 8 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.