×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

representing a recursive/self join table as a multi-level dimension

representing a recursive/self join table as a multi-level dimension

representing a recursive/self join table as a multi-level dimension

(OP)
One of the things that I have been trying to solve, is how to represent a recursive/self join table as a multi-level dimension.
For example, you have a team table that is joined to itself to create a team hierarchy - (with the following fields : team#, teamdescr, parentteam# - where parent team number joins to team#)

How do you represent this ?

RE: representing a recursive/self join table as a multi-level dimension

This sounds more like a Relational question than a OLAP/Multidimensional question. Forgive me if I have misunderstood...

You have represented the relationship (one to many recursive) properly in your table.

An example SQL statement to retrieve team info including parent team (self join) would look something like this:

SELECT Team.team, Team.teamdescr, ParentTeam.teamdescr
FROM Team LEFT JOIN Team AS ParentTeam ON Team.team = ParentTeam.parentteam

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