• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 89
  • Last Modified:

date warehouse date dimension design

I'm trying to figure out this design.


I have a count measure "Count(ids)" in my fact table.  I also have the standard date dimension which is joins up to fine.  I'm trying to figure out where to put my YTD Dimension or if it goes into the standard date dimension.  The measure is the count(ids) from the beginning of the year to the most current Saturday.  Do I put the ytd field in the date dimension or should I make it it's own dimension.
0
elucero
Asked:
elucero
  • 3
  • 3
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi Elucero,

Aggregate functions (count, sum, average, etc.) do not normally go in the fact table.  The are computed from the fact table and limited by the dimension (date) table.

You might have other tables that contain summary values, but that's different from the fact table.
1
 
eluceroAuthor Commented:
Thank you.  I'm sure I'm not explaining this correctly.
0
 
Kent OlsenData Warehouse Architect / DBACommented:
Can you give me some more detail?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
eluceroAuthor Commented:
I ended up making a ytd dimension and not putting those particulars dates in the regular date dimension.  Thanks for your help.
0
 
Kent OlsenData Warehouse Architect / DBACommented:
That's not a bad idea.  I assume that you just reused the value of the data dimension key in the fact table?
1
 
eluceroAuthor Commented:
Yes, thanks.  I just asked another question bout date of death can you help w/that.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now