Outer Join on attribute

[Sridharan]

Hello,

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?

TIA

Sridharan

 

[reisw]

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.

 

[Sridharan]

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.

 

[nlim]

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