Solved

date warehouse date dimension design

Posted on 2016-08-09
6
74 Views
Last Modified: 2016-08-17
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
Comment
Question by:elucero
  • 3
  • 3
6 Comments
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 500 total points
ID: 41749667
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
 

Author Comment

by:elucero
ID: 41749736
Thank you.  I'm sure I'm not explaining this correctly.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 41749737
Can you give me some more detail?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:elucero
ID: 41760042
I ended up making a ytd dimension and not putting those particulars dates in the regular date dimension.  Thanks for your help.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 41760077
That's not a bad idea.  I assume that you just reused the value of the data dimension key in the fact table?
1
 

Author Comment

by:elucero
ID: 41760084
Yes, thanks.  I just asked another question bout date of death can you help w/that.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question