Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Days
For cube designs that store data at the daily level of detail, there are a number of different options such as using a three dimensional approach with year, week, and weekday.
Note
The maintenance using this approach is low; an additional year needs to be added to the year dimension once each year.
If your requirements for data are to capture and store data lower than a day (such as an hour or even a minute), an additional dimension should be added for that day's detail, along with appropriate aggregations or rollups.
