dimensional modeling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

viki - 04 Dec 2005 10:37 GMT

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?

Reply to this Message

Dejan Sarka - 04 Dec 2005 11:08 GMT

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).

Signature

Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com

>I need some guideline for designing diemsional model for the situation
> given below. Suppose we track individual sales transactions alongwith
[quoted text clipped - 3 lines]
> only actual sales but also compares it targets alloted? Where should be
> alloted target amounts need to be stored?

Reply to this Message

Peter Nolan - 10 Dec 2005 17:08 GMT

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

Reply to this Message