Answer Posted / balanandam

select * from((select * from emp order by sal desc where rownum<=5)MINUS(select * from emp order by sal desc where rownum<=4))

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!

1953

---

how to connect datamarts

2735

---

What are types of batch available in cognos?

916

---

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.

2045

---

What is difference between page break and section report?

1164

---

What is set to be cardinality?

1108

---

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1645

---

What you mean by drill across and what is the difference between drill through, drill across?

968

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2251

---

how you migrate reports to cognos 8 from previous versions?

983

---

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

1996

---

What errors and types of errors you faced in Cognos ReportNet?

4096

---

What are the types of studio?

1093

---

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

2251

---

What is the use of report studio?

975

---