write my assignment 11324

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

 
"Not answered?"
Get the Answer