Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 86

Date].[Calendar].[Date].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM
( SELECT
( { [Promotion].[Promotions].[Promotion
Name].&[5] } ) ON COLUMNS
FROM [AdventureWorksSample])
WHERE (
[Promotion].[Promotions].[Promotion
Name].&[5] )
CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE,
FORMAT_STRING, FONT_NAME, FONT_SIZE,
FONT_FLAGS
With the updated MDX, the result set is much smaller, as shown in the fol-
lowing screenshot:
10. Click on the Excel icon found next to the Language dropdown on top of the
screen—the icon's tool tip states Analyze in Excel . Again, the prerequisite
for analyzing in Excel is that you have Excel installed on your computer. Ex-
cel isn't part of the SQL Server product suite and isn't installed as part of the
Analysis Services installation.
11. This opens an Excel worksheet with a Pivot Table. Select the Unit Price and
Total Product Cost measures, then drag the Promotions hierarchy onto
rows and Due Date.Calendar hierarchy on filters. Now your Pivot Table
should resemble the next screenshot, and you can browse the data as in any
other Pivot Table—choose various years within the due date dimension's cal-