Outer joins in FW

[addicted2cognos]

Anybody faced problems using outer joins in fw(trying to implement a left outer join) with an inner join to another table

[Arpitagrawal9]

What is the issue you are facing,In case you want to impliment a Left/Right Outer join,you can change the cardinality to 0 for the side which is deficit of the information.

Hope this helps,Let me know in case you still face any issue.

Regards,
Arpit

[wyconian]

Hi

Arpit answers is really good for the question you asked.  But, outer joins are bad in terms of performance and can make it harder to write reports.

Is your model based on a  datawarehouse?  If it is and you're using Data Manager as the ETL engine you can add something called a static member to the dimension builds.  This is like a default value for the 'Unknown' or 'missing' record in the dimension.  When you then come to do the surrogate key substitution on the fact table you can decide to use the static member if the real record cab't be found or is missing.  In this way you can completely remove the need for outer joins in the model, improving performance and making the reports easier to write :)