Regnecentralen /
National Danish Center for Advanced Calculations (NDCAC)
Contact Us | Login | rcnet
 Search
   Home    Research    Products    Press    About  
  Publications
  Time Dimension Generator
  Legal information
Billetsystemet 2006 v2.1
Billetsystemet 2006 v2.1 has been released! Click here to learn more

Regnecentralen's History
The exciting history of Regnecentralen

People at Regnecentralen
Regnecentralen's main profiles

Kassesystemet at Work
"Kassesystemet" being used in a women's clothing store - click here to learn more

So Easy!
Anybody can use Billetsystemet!

Note on the IsToday-column
The IsToday-column is a flag indicating which date is "today". The column contains only 0's when generated by this service and it is up to you (i.e. your ETL) to set the flag.

The flag makes the very common "current day", "current week", "current month", "year-to-date", etc. calculations very easy. By using the flag set by the ETL-process instead of using the system date, the "current date" is always the date of the last successful ETL-job, i.e. the "today" of your data warehouse. In other words, if you update the time table at the very end of your ETL job (i.e. issues an UPDATE setting a '1' on the row with today's date and '0' everywhere else) - the global definition of "today" is readily available for your data marts to use. And furthermore: It efficient.

Example: Common sets in Analysis Services 2005
As mentioned before, "CurrentDate"-calculations are very common on cubes. Here are a few examples from Analysis Services 2005 (MDX calculated sets).

[CurrentDate] (returns "today"-member)
EXISTS([TimeDim].[Day].[Day], [TimeDim].[IsToday].&[1])

[CurrentWeek] (week of "today")
EXISTS([TimeDim].[Week].[Week], [TimeDim].[IsToday].&[1])

[CurrentMonth] (month of "today")
EXISTS([TimeDim].[Month].[Month], [TimeDim].[IsToday].&[1])


Other time calculations are easy as well:

[PreviousDate] (returns "yesterday"-member)
[CurrentDate].Item(0).Lag(1)

[PreviousWeek] ("last week"-member)
[CurrentWeek].Item(0).Lag(1)

[PreviousMonth] ("last month"-member)
[CurrentMonth].Item(0).Lag(1)

Example: Query
This query will return data from last week:

SELECT [rows and columns...]
FROM [Cube]
WHERE ([PreviousWeek])

Most Downloaded Publications
Specifying OLAP Cubes On XML Data, Journal Edition (PDF)
Converting XML Data to UML Diagrams for Conceptual Data Integration (PDF)
Discovering Multidimensional Structure in Relational Data (PDF)


External References
DBLP Computer Science Bibliography
The OLAP Council
Datawarehouse Tools and Tutorials
DP Research Unit, Aalborg University
ACM SIGMOD
Scientific and Statistical Database Management (SSDBM)


External References Free Math Software
GNUPlot
Scilab
Octave
R Project


Popular Products
Billetsystemet Net
Billetsystemet 2006
Kassesystemet
Time Dimension Generator


Buy a Product
Request a phone call from the Sales Department


Legal Information | Privacy Policy | About Regnecentralen | Contact Regnecentralen
Regnecentralen's website is optimized for Internet Explorer 6+ @ 1024x768x24. Copyright Regnecentralen 2000-2008, all rights reserved. Material from the website (except press material) may not be copied or used in any way (including personal use) without prior permission. Please send questions and comments regarding the website to the webmaster. All activity is logged. Your IP: 54.82.112.193.