Database Reference
In-Depth Information
concern for a sample database with a few hundred members in the calendar
hierarchy, but real-world applications are likely to have much larger dimen-
sions.
6. Flattening the result set does not allow you to have the same experience
offered by Excel and other cube-browsing tools. Note that the SSMS cube
browser ignored the formatting choices we applied to the Unit Price and
Total Product Cost measures.
7. The new cube browser does offer a nice improvement in being able to review
and edit the MDX generated by SSMS. If you click on the Design Mode but-
ton found at the right-most corner of the top ribbon, you will see the following
MDX statement:
SELECT
NON EMPTY { [Measures].[Unit Price],
[Measures].[Total Product Cost] } ON
COLUMNS,
NON EMPTY { ([Due
Date].[Calendar].[Date].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM [AdventureWorksSample]
CELL PROPERTIES VALUE, BACK_COLOR,
FORE_COLOR, FORMATTED_VALUE,
FORMAT_STRING, FONT_NAME, FONT_SIZE,
FONT_FLAGS
Tip
Downloading the example code
You can download the example code files for all Packt topics you have
purchased from your account at http://www.packtpub.com . If you pur-
chased this topic elsewhere, you can visit http://www.packtpub.com/sup-
port and register to have the files e-mailed directly to you.
Search WWH ::




Custom Search