Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 90
  • 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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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