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!
  • Students Click Here

*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 Dimension With Multiple Sets for Different Fiscal Year Definition

Time Dimension With Multiple Sets for Different Fiscal Year Definition

Time Dimension With Multiple Sets for Different Fiscal Year Definition

I work for an interntional company that provides Data Warehouse modules to its clients across the globe.  In an attempt to accomodate different Fiscal Year defintions for different clients, they have created an un-orthodox Time Dimension... it has different set of time records for different domains in the same Time table.

For example, for a company in, say, Mexico, with a domain of QMEX, it will have it own set of time records with its fiscal year starting in Sept and ending in Aug.
Or for a company in Canada, with a domain of QCAN, it will have its own set of time records, in the same table, with its fiscal year starting in Nov and ending in Oct.

This is creating a number of problems, especially with respect to hierarchical traversal... and, of course, this makes the attributes flexible where as normally they would be rigid.

Also, they are using for the Primary Key a decimal(18,0) data type.

I've never seen anything like this before (5 yrs BI) and I'm wondering if anyone else has.. and whether this a good idea or bad idea... and why?

RE: Time Dimension With Multiple Sets for Different Fiscal Year Definition

Make separate hierarchies for each fiscal calendar.  You'd have your normal calendar hierarchy, Oct-Sep fiscal hierarchy, Jul-Jun fiscal hierarchy, 4-4-5 hierarchy, etc.  If you need to analyze across different calendars, then choose the normal calendar hierarchy.

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!

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