non-additive facts are :

Options
- facts that cannot be grouped for some dimensions present in the fact table.
- facts that cannot be summed up for some dimensions present in the fact table.
- facts that cannot be summed up for any dimension present in the fact table.
- facts that cannot be grouped for any dimensions present in the fact table.

CORRECT ANSWER : facts that cannot be summed up for any dimension present in the fact table.

Discussion Board
Non-additive facts

Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. A good approach for non-additive facts is, where possible, to store the fully additive components of the non-additive measure and sum these components into the ?nal answer set before calculating the ?nal non-additive fact. This ?nal calculation is often done in the BI layer or OLAP cube.

Prajakta Pandit 03-16-2017 05:45 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲