Answer Posted / navneet singh sahni

List Report and Crosstab report both contains rows and
columns but difference is list report is a detail report
for analysis whreas crosstab report is the intersection of
data or summarizied data for analysis.

Why need staging area database for dwh?

739

---

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!

1678

---

What is the difference between Open Connection command ang Open Session Command?

1996

---

i was asked what are the caluclations done by you in your report? plz give reply

1819

---

What is meant by junk dimension?

658

---

---

Explain the characteristics of cognos?

688

---

What junk dimension contains?

659

---

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

1754

---

What are the two types of framework manager?

763

---

Explain difference between powerplay transformer and power play reports?

639

---

please please give me some banking calculations in framework manager.

1748

---

------------------What is Inline Query?

1878

---

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1773

---

Define datastores in cognos?

637

---

Define the cognos reporting tool?

647

---