|
Home > Archive > MS SQL Data Warehousing > December 2005 > dimensional modeling
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dimensional modeling
|
|
|
| I need some guideline for designing diemsional model for the situation
given below. Suppose we track individual sales transactions alongwith
different categories of product, areas and employee who made sale.
Sales targets have alreay been assigned to employees for a given time
period eg. quarter. How should we design DM which allows to track not
only actual sales but also compares it targets alloted? Where should be
alloted target amounts need to be stored?
| |
| Dejan Sarka 2005-12-04, 7:23 am |
| In SQL 2005 UDM, you can have a single dimension connected to two fact
tables on a different levl of granularity, which is exactly what you need
(sales transactions vs. target sales). Check the "Defining Dimension
Granularity within a Measure Group" part of the Analysis Services Tutorial
in SQL 2005 BOL (http://msdn2.microsoft.com/en-us/library/ms166573.aspx).
--
Dejan Sarka, SQL Server MVP
Mentor
www. SolidQualityLearning
.com
"viki" <waqer@yahoo.com> wrote in message
news:1133692623.706401.175280@z14g2000cwz.googlegroups.com...
>I need some guideline for designing diemsional model for the situation
> given below. Suppose we track individual sales transactions alongwith
> different categories of product, areas and employee who made sale.
> Sales targets have alreay been assigned to employees for a given time
> period eg. quarter. How should we design DM which allows to track not
> only actual sales but also compares it targets alloted? Where should be
> alloted target amounts need to be stored?
>
| |
| Peter Nolan 2005-12-10, 11:23 am |
| Hi Viki,
I have a beginners page on my web site www.peternolan.com. It contains
links to books I recommend. Ralphs books cover these areas in detail.
There are also sample databases for what you are asking....The Data
Warehouse Design Solutions book would also be useful to you as you will
surely not stop at merely doing sales tracking....
Best Regards
Peter
www.peternolan.com
|
|
|
|
|