MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
Book
Subscription
Free Trial for 7 days
$12.99/m after trial
eBook + Subscription
$12.99
eBook
$32.99
Print + eBook
$54.99
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
Subscription
Free Trial for 7 days
$12.99/m after trial
eBook + Subscription
$12.99
eBook
$32.99
Print + eBook
$54.99
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook + Subscription?
Download this book in EPUB and PDF formats
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
-
Free ChapterElementary MDX Techniques
- Elementary MDX Techniques
- Introduction
- Skipping axis
- Handling division by zero errors
- Setting special format for negative, zero and null values
- Applying conditional formatting on calculations
- Setting default member of a hierarchy in MDX script
- Implementing NOT IN set logic
- Implementing logical OR on members from different hierarchies
- Iterating on a set in order to reduce it
- Iterating on a set in order to create a new one
- Iterating on a set using recursion
- Dissecting and debugging MDX queries
- Using NON_EMPTY_BEHAVIOR
- Optimizing MDX queries using the NonEmpty() function
- Implementing logical AND on members from the same hierarchy
-
Working with Time
- Working with Time
- Introduction
- Calculating the YTD (Year-To-Date) value
- Calculating the YoY (Year-over-Year) growth (parallel periods)
- Calculating moving averages
- Finding the last date with data
- Getting values on the last date with data
- Hiding calculation values on future dates
- Calculating today's date using the string functions
- Calculating today's date using the MemberValue function
- Calculating today's date using an attribute hierarchy
- Calculating the difference between two dates
- Calculating the difference between two times
- Calculating parallel periods for multiple dates in a set
- Calculating parallel periods for multiple dates in a slicer
-
Concise Reporting
- Concise Reporting
- Introduction
- Isolating the best N members in a set
- Isolating the worst N members in a set
- Identifying the best/worst members for each member of another hierarchy
- Displaying few important members, others as a single row, and the total at the end
- Combining two hierarchies into one
- Finding the name of a child with the best/worst value
- Highlighting siblings with the best/worst values
- Implementing bubble-up exceptions
-
Navigation
- Navigation
- Introduction
- Detecting a particular member in a hierarchy
- Detecting the root member
- Detecting members on the same branch
- Finding related members in the same dimension
- Finding related members in another dimension
- Calculating various percentages
- Calculating various averages
- Calculating various ranks
-
Business Analytics
- Business Analytics
- Introduction
- Forecasting using the linear regression
- Forecasting using the periodic cycles
- Allocating the non-allocated company expenses to departments
- Calculating the number of days from the last sales to identify the slow-moving goods
- Analyzing fluctuation of customers
- Implementing the ABC analysis
-
When MDX is Not Enough
- When MDX is Not Enough
- Introduction
- Using a new attribute to separate members on a level
- Using a distinct count measure to implement histograms over existing hierarchies
- Using a dummy dimension to implement histograms over non-existing hierarchies
- Creating a physical measure as a placeholder for MDX assignments
- Using a new dimension to calculate the most frequent price
- Using a utility dimension to implement flexible display units
- Using a utility dimension to implement time-based calculations
-
Context-aware Calculations
- Context-aware Calculations
- Introduction
- Identifying the number of columns and rows a query will return
- Identifying the axis with measures
- Identifying the axis without measures
- Adjusting the number of columns and rows for OWC and Excel
- Identifying the content of axes
- Calculating row numbers
- Calculating the bit-string for hierarchies on an axis
- Preserving empty rows
- Implementing utility dimension with context-aware calculations
-
Advanced MDX Topics
- Advanced MDX Topics
- Introduction
- Displaying members without children (leaves)
- Displaying members with data in parent-child hierarchies
- Implementing the Tally table utility dimension
- Displaying random values
- Displaying a random sample of hierarchy members
- Displaying a sample from a random hierarchy
- Performing complex sorts
- Using recursion to calculate cumulative values
-
On the Edge
- On the Edge
- Introduction
- Clearing the Analysis Services cache
- Using Analysis Services stored procedures
- Executing MDX queries in T-SQL environments
- Using SSAS Dynamic Management Views (DMV) to fast-document a cube
- Using SSAS Dynamic Management Views (DMVs) to monitor activity and usage
- Capturing MDX queries generated by SSAS front-ends
- Performing custom drillthrough
About this book
- Publication date:
- August 2011
- Publisher
- Packt
- Pages
- 480
- ISBN
- 9781849681308
Download code from GitHub