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

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

---

Can anyone tell me the step by step process how to connect cognos to oracle?

3 Answers  

---

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

2 Answers   IBM,

---

write a query to display to 10 max record from the employee table?

2 Answers   HCL,

---

what is the difference between count and running-count functions?

1 Answers  

---

What is set to be Cognos configuration?

0 Answers  

---

Which studio is used to create reports?

0 Answers  

---

Explain about embedded & standalone filters?difference between them

1 Answers  

---

How you will do the estimation for a task?

1 Answers   iGate,

---

my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?

0 Answers  

---

what is the difference between filter and condition?

0 Answers   IBM,

---

What is Lookup ,bridgeing tables where they will use in the Dataware house

2 Answers   IBM,

---