subject
Business, 22.07.2020 05:01 maddysmall32

Create hierarchies for the order dates and product categories as follows so you can easily find information about a specific product sale on any date: a. Use the Manage option on the Power Pivot tab to display the Data Model inDiagram View.
b. Create a new hierarchy and use Dateas the hierarchy name.
c. Add the OrderDate(Year), OrderDate(Quarter), OrderDate(Month) and OrderDate fields in that order to the new Date hierarchy. (Hint: Do not select the OrderDate(Month Index) field.)
d. Create another new hierarchy and use Productas the hierarchy name.
e. Add the Category and Description fields in that order to the new Product hierarchy, and close the Power Pivot window.
f. Remove the fields from the Columns and Rows boxes.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 01:00
How does the economy of cuba differ from the economy of north korea? in north korea, the government’s control of the economy has begun to loosen. in cuba, the government maintains a tight hold over the economy. in cuba, the government’s control of the economy has begun to loosen. in north korea, the government maintains a tight hold over the economy. in north korea, there is economic uncertainty in exchange for individual choice. in cuba, there is economic security in exchange for government control. in cuba, there is economic uncertainty in exchange for individual choice. in north korea, there is economic security in exchange for government control.\
Answers: 2
question
Business, 22.06.2019 08:10
Bakery has bought 250 pounds of muffin dough. they want to make waffles or muffins in half-dozen packs out of it. half a dozen of muffins requires 1 lb of dough and a pack of waffles uses 3/4 lb of dough. it take bakers 6 minutes to make a half-dozen of waffles and 3 minutes to make a half-dozen of muffins. their profit will be $1.50 on each pack of waffles and $2.00 on each pack of muffins. how many of each should they make to maximize profit, if they have just 20 hours to do everything?
Answers: 3
question
Business, 22.06.2019 11:10
Verizon communications, inc., provides the following footnote relating to its leasing activities in its 10-k report. the aggregate minimum rental commitments under noncancelable leases for the periods shown at december 31, 2010, are as follows: years (dollars in millions) capital leases operatingleases 2011 $97 $1,898 2012 74 1,720 2013 70 1,471 2014 54 1,255 2015 42 1,012 thereafter 81 5,277 total minimum 418 $ 12,633 rental commitments less interest and (86) executory costs present value of 332 minimum lease payments less current (75) installments long-term obligation $257 at december 31, 2010 (a) confirm that verizon capitalized its capital leases using a rate of 7.4 %. (b) compute the present value of verizon's operating leases, assuming an 7.4% discount rate and rounding the remaining lease term to 3 decimal places. (use a financial calculator or excel to compute. do not round until your final answers. round each answer to the nearest whole number.)
Answers: 2
question
Business, 22.06.2019 14:40
You are purchasing a bond that currently sold for $985.63. it has the time-to-maturity of 10 years and a coupon rate of 6%, paid semi-annually. the bond can be called for $1,020 in 3 years. what is the yield to maturity of this bond?
Answers: 2
You know the right answer?
Create hierarchies for the order dates and product categories as follows so you can easily find info...
Questions
question
Mathematics, 02.08.2019 04:00
question
Mathematics, 02.08.2019 04:00