What are semi additive facts examples?

Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others. For example if you have the number of items in the warehouse for each day, you can sum up the items for each day (total warehouse of the day), but it make no senso to sum up in the year.

What are non-additive measures?

Non-additive measures are measures that cannot be aggregated across any of the dimensions. Non-additive measures are usually the result of ratios or other mathematical calculations. The only calculation that can be made for such a measure is to get a count of the number of rows of such measures.

Which of the following measure is fully additive?

sales
The most flexible and useful facts are fully additive; additive measures can be summed across any of the dimensions associated with the fact table. An example of a fully additive measure is sales (purchases from a store). You can add hourly sales to get the sales for a day, week, month, quarter, or year.

Which is an example of a semi additive measure?

Semi-additive calculations are the hardest ones: a semi-additive measure uses SUM to aggregate over some dimensions and a different aggregation over other dimensions – a typical example being time. As an example, we use a model that contains the balance of current accounts.

When to use semi-additive measures in time intelligence?

Other Time Intelligence functions are useful in semi-additive measures, for getting the first and last date of a period (year, quarter, or month). These are helpful whenever you need to extract a value of a selection that is smaller than the entire period considered.

Why is lastdate used in semi additive measures?

This is because LASTDATE implies a context transition that hides the external filter context. Other Time Intelligence functions are useful in semi-additive measures, for getting the first and last date of a period (year, quarter, or month).

What are non additive measures in a fact table?

Non-additive – measures that cannot be added across any dimension. Semi-additive – measures that can be added across some dimensions. A fact table might contain either detail level facts or facts that have been aggregated (fact tables that contain aggregated facts are often instead called summary tables).