<div>
Thank you. &nbsp;I'm sure I'm not explaining this correctly.
</div>


Thank you.  I'm sure I'm not explaining this correctly.

<div>
Can you give me some more detail?
</div>


<div>
I ended up making a ytd dimension and not putting those particulars dates in the regular date dimension. &nbsp;Thanks for your help.
</div>


I ended up making a ytd dimension and not putting those particulars dates in the regular date dimension.  Thanks for your help.

<div>
That's not a bad idea. &nbsp;I assume that you just reused the value of the data dimension key in the fact table?
</div>


That's not a bad idea.  I assume that you just reused the value of the data dimension key in the fact table?

<div>
Yes, thanks. &nbsp;I just asked another question bout date of death can you help w/that.
</div>


Yes, thanks.  I just asked another question bout date of death can you help w/that.

<div>
<div class="content wysiwyg-content">
I'm trying to figure out this design.<br />
<br />
<br />
I have a count measure &quot;Count(ids)&quot; in my fact table. &nbsp;I also have the standard date dimension which is joins up to fine. &nbsp;I'm trying to figure out where to put my YTD Dimension or if it goes into the standard date dimension. &nbsp;The measure is the count(ids) from the beginning of the year to the most current Saturday. &nbsp;Do I put the ytd field in the date dimension or should I make it it's own dimension.
</div>
</div>


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.

date warehouse date dimension design

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.