Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Time dimensions on multiple date columns

Time dimensions on multiple date columns

Time dimensions on multiple date columns

If it helps in the answer I am using MONDRIAN as my OLAP to mysql interface, although this problem may just be OLAP.

I have a fact table that has multiple date columns.
I can make a time dimension but it has to be joined to a particular date column. But I want to produce output such that there is a navigable time dimension and there are multiple measures on more than one date column.

The only way I can see to do this is to take all the date columns and put them into another table that has a single date column and a key back to the fact table.

Or is there another way?

RE: Time dimensions on multiple date columns

The way you mentioned is the best way, and gives the added benefit of being able to define each date with more than one value. For instance, the calendar date of October 1, 2006 can also be the beginning of a fiscal year. Or, if you have a business based heavily on quarters, you can designate each day as belonging to a certain week of the month, quarter, and year. (There are 13 weeks in a quarter but only 4 in a month).

The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close