Answered Questions

  • Aug 15 2005
    07:24 PM
    28102
    32

    What are non-additive facts?

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: Praveen

    • Aug 15th, 2005

    # Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table. 
    # Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. 
    # Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.

    cognos_anu

    • Jun 20th, 2017

    The facts which cannot be summed up across any dimension.
    for e.g. Percentage, temperature

    Srikant

    • Nov 20th, 2016

    Please give me a fact table where I cannot add the percentage. Especially if the percentage is calculated for that particular fact table. Are we saying that percentages stored in the fact table might ...