How to create a Left Outer Join in FM? Please explain.

Answer Posted / kumar

select 2 query subjects , then define the relationship 0-1
1-1 if that is between 2 Dimensions.
If that is between dimension, Fact 0-1 1-n {0-1(dimension),
1-n (fact )}

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain informatica architecture?

558


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

1701


Define the slice and dice?

571


hi friends pls forward impropmtu interview question

1684


What is a Datastore in Cognos?

795






describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

1895


What is zero-foot print?

594


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

566


Explain about scorecarding?

1625


How create measures and dimensions?

601


how to create measures and dimensions?

608


whats the difference between previous version of cognos and cognos 8 BI?

4747


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1417


can we insert all types of charts in a list report? what r the realtime prompts?

1665


1. Explain your project.

1590