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

Slightly-Off Granularity

Slightly-Off Granularity

Slightly-Off Granularity

I have an interesting problem with a fact table that I'm creating. In the source data, which relates to school enrollment, some sources provide separate enrollment data for male and female, and others only provide it for all students, regardless of gender. It seems bad to create an entirely separate fact table for just the gender business, but at the same time, each row would have a slightly different granularity if I kept them in the table, and slicing on gender lines wouldn't give an accurate representation of the data. The same holds true for demographic data, where some schools report enrollment broken down by ethnicity, and and some don't. What's the best way to proceed with this?

RE: Slightly-Off Granularity

I would create the fact with a gender key for all data and define the gender dimension as:

1. Male
2. Female
3. Unspecified

This should give you all reporting options. Abstain from using the gender dimension would yield gender independant data, but you could still add this for more detailed analysis..  

Ties Blom

RE: Slightly-Off Granularity

I concur with Ties Blom (and give a star).

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