SQL Server Analysis Services - Dimensional Modeling Concepts
page 5 of 5
by Nidal Arabi
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 26322/ 25

Summary

In this article, an overview of dimensions and measures was provided. Some general concepts were introduced. The concepts introduced here are illustrated with a sample picture from Excel (very simplified view). The idea is that you have the capability to filter by region or by sales person and have the sales amount changed. We also showed the two way of creating dimensions schema: Star and Snow Flake. In the next article we will begin the practical implementation of an Analysis Services project, stay tuned and happy BI.


View Entire Article

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-29 2:16:14 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search