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
Define the cognos reporting tool?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
Explain the difference between native sql and cognos sql?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Define dimensions?
Why need staging area database for dwh?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
How can I test reports in cagonos?
what is log in cognos?
What is the difference b/w macros and prompt?
---------------Describe OLAP Reporting and RDBMS Reporting?
Can you define snapshot?
What is metric store database?
how can I test reports in cagnos?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?