ENDNOTES

1. For the sake of clarity we do not show here how time granularity is handled in the translation; usually, this will depend on the underlying DBMS.

2. Notation: The dimensions' sub-indices represent their position in the fact table to which they are bound. In the implementation, constructions of the form x 4 Y:x, are replaced by x[t] -+ Y:x, in order to simplify parsing.

3. In an actual implementation, Now can be replaced by Sysdate() or any function returning the current time.

4. Actually, the parenthesis is not required.