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

Outer Join on attribute

Outer Join on attribute

Outer Join on attribute


Suppose I've got two metrics and one attribute and want to list the values of these two metrics for each value of the given attribute irrespective of whether the value exist or not. Presently i'am getting the attributes for which both metrics provides a value. I tried metric join as Outer Join but of no use. Any insights on how to make this work?



RE: Outer Join on attribute

From what you have described an outer join on the metrics seems to be the right thing to do. I would make sure that both metrics are configured as outer join. Maybe try running one report each with each metric and making sure that there really are valuse that you are missing. I have also seen in the past that sometimes a report will stay cached and it keeps pulling up the cached report. Make sure there are no caches and try running it again. I can't think of any other reason that it wouldn't work. We use outer joins on all of our metrics and they work fine.

RE: Outer Join on attribute

Both the metrics join type has been made as Outer Join and I'm made sure it doesn't run from cache.

Well I do have some missing values when I have both metrics in the report. I also looked at the SQL generated by MicroStrategy and I found that it creates two temporary tables and dumps values of one metric into one table and other metric into another table and finally it takes all the attribute which exists in both the tables. Thatz where i would like to display all the values. Will having a filter embedded into the metric will have any effect on the join type coz i've got filter into both metrics.

RE: Outer Join on attribute

have you tried using the "Outer Join to Lookup Table" VLDB setting?

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