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 a Cube?

0 Answers  

---

In how many ways we can apply the security to a cube in Transformer? Explain?

1 Answers   Wipro,

---

is there any possibility to hide items other than render variable?

2 Answers   IBM,

---

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

---

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,

---

Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,

---

Can we install cognos on windows 7?

4 Answers  

---

What is cognos connection?

0 Answers  

---

what is report burn and where it occurs

3 Answers   IBM, Target,

---

How can we convert imr report into Impromptu web report?

3 Answers  

---

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,

---

How many fact tables and dimension tables in your project?

3 Answers   IBM,

---