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