Question: A . Get the following result using ROLLUP operation on the data cube created in last assignment. 1 . Total Sale value by - a
A Get the following result using ROLLUP operation on the data cube created in last assignment.
Total Sale value by
a Each Year
b Each Quarter
c Each Month
d Each Product
e Each Year,Quarter Combination
f Each Year,Month Combination
g Each Year,Product Combination
h Each Quarter,Month Combination
i Each Quarter,Product Combination
j Each Month,Product Combination
k Each Year,Quarter,Month Combination
l Each Year,Quarter,Product Combination
m Each Year,Month,Product Combination
n Each Quarter,Month,Product Combination
o Total Sales value.
B Use DRILL DOWN on Quarter to create the CUBE on dimention year month, product, salse
amount and perform the following operation
a Each Year
b Each Month
c Each Product
d Each Year,Month Combination
e Each Year,Product Combination
f Each Month,Product Combination
g Each Year,Month,Product Combination
C Create a dice from cube created in last assignment on product A & C month having ODD
number and Quarter having EVEN number and execute the following opertions
Total Sale value by
a Each Year
b Each Quarter
c Each Month
d Each Product
e Each Year,Quarter Combination
f Each Year,Month Combination
g Each Year,Product Combination
h Each Quarter,Month Combination
i Each Quarter,Product Combination
j Each Month,Product Combination
k Each Year,Quarter,Month Combination
l Each Year,Quarter,Product Combination
m Each Year,Month,Product Combination
n Each Quarter,Month,Product Combination
o Total Sales value.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help