Mastering Dimensions of Time
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
9,594 reads
time dimension
Creating Custom Calendars in SQL Server Analysis Services
Businesses often have custom financial calendars - adapting these for use in SSAS can often be challenging - this article shows you how to do it.
2010-09-28
5,961 reads
Date Dimensions in T-SQL using CTE
T-SQL Script for Time Dimension Table Data: Populates Data between two dates for Reporting Solutions.
2011-07-04 (first published: 2010-06-14)
3,756 reads
Sending mails using DTS
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-11-22
DTS OLAP options limited?
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-15
RE: Adding selects
And add the date to that solution to yield SELECT item_no, date, sum(qty) FROM table GROUP BY item_no, date
2003-08-18
RE: Smily question
You know, I don't think the majority of people even have a clue on this one so they jsut ignore it. Of course it is a good one if you have an urgent issue where something is going wrong and you need assistance but again how many knew what it meant. Most people even just […]
2003-07-18
2 reads
2003-07-14
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers