Answer / palzkumar

Three types of Fact...

1. Additive Fact: Additive facts are facts that can be
summed up through all of the dimensions in the fact table.

2. Semi-Additive Fact: Semi-additive facts are facts that
can be summed up for some of the dimensions in the fact
table, but not the others.

eg : Bank Balances - you can take a bank account as Semi-
Additive since a current balance for the account can't be
summed as time period; but if you want see current balance
of a bank you can sum all accounts current balance.

3. Non-Additive Fact: Non-additive facts are facts that
cannot be summed up for any of the dimensions present in
the fact table.
Eg: . Ratios, Averages & Variance

rgds,
palz

Answer / arkchowdary

Types of Facts------------------ Additive Fact,
Semi-Additive Fact,
Non-Additive Fact.
Perodic Fact,
Accumilative Fact

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

---

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

---

What is Stich Query in Reportnet?

10 Answers  

---

What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,

---

What is the difference between filter & Condition?

3 Answers   MetLife, TCS,

---

How much time it will take to develop a report in real time? It depends upon the complexity of the report, so tell me the approximate time period for a simple list, cascading, master-detail, drill-through,..…etc?

3 Answers  

---

What is a dashboard in Cognos Report Studio and how do we creae it

2 Answers  

---

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

0 Answers   Bank Of America,

---

what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---

9. What was the most complex type of report you dealt with?

0 Answers  

---

Define catalog in cognos and write its various types?

0 Answers  

---

Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 Answers  

---