For each of the following statements determine whether the measure is additive, semi-additive or non-additive.
A fact exists for (d, p, c, s) if product p was sold to customer c from shop s on day d. The measure is total price.
A fact exists for (d,p,s ) for each product p, each shop s, and each day d. The measure is the total inventory of p in s on d.
A fact exists for (d,p,s) for each product p, each shop s, and each day d. The measure is the total amount of p sold in s in the year until day d.
A fact exists for (b,c,d) if currency c was exchanged in bank branch b on day d. The measure is the average exchange rate between c and US dollars for all transactions involving c on day d.
Consider a data cube that consists of a lattice of cuboids. Let us assume that the number of dimensions is n, in other words the lowest level cuboid has n dimensions.
How many cuboids are there in a n-dimensional data cube if there are no hierarchies associated with each dimension.
Can anyone help me with these questions and explain why? I am weak at data warehouse! thank you