Assume that we have a data cube as follows:
DairyFarms = { <Name, Time , Product> , <Sales> , <Sum> }
Name = {Farm1, Farm2, Farm3, Farm4}
Time = {Jan, Feb, Mar , ..... , Dec}
Product = {Milk, Butter, Cheese, Yogurt}
Suppose I want to retrieve the sales of Cheese across all the farms during January. Which of the following two queries is correct?
i) DairyFarms[Name*][Jan][Cheese]
ii) DairyFarms[][Jan][Cheese]
Do both of them mean the same or is there any difference between them w.r.t. correctness and/or efficiency?