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

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1828


is there any difference between operational database and data base?if yes what r they?

1588


What are the different types of reports present in cognos?

574


How can create users and permissions in cognos?

562






What is a Cube?

688


What is zero-foot print?

598


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

1626


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2162


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

558


--------------Diff b/w ODS and OLAP?

2757


What is called materialized view?

597


What are all the types of hierarchies?

676


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1547


When we save a report in report studio with what extn it save?

658