Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX

by dennyglee Categories: Analysis ServicesTags: · Leave a comment

Want to know more about SQL Server 2012 Analysis Services – Multidimensional and Tabular?  Well, check out SQL Server 2012 Analysis Services with MDX and DAX!  The book is co-written by my SQL BI teammates – so thank goodness for that (to compensate for my lack of writing grace)!   So what’s in the book? Shows how to utilize SQL Server Data Tools to build Analysis Services multidimensional and tabular databases Shares fundamental concepts of DAX and MDX and dives into advanced concepts such as parent-child hierarchies and time-based analysis Demonstrates methods for analyzing and optimizing DAX and MDX query…

Rate this:

Pivots, Cube Formulas, Named Sets … Oh my!

by dennyglee Categories: PowerPivotTags: · · 8 Comments

Over the last few days, @PowerPivotPro has been calling me out for diving into the deep end into his world of Excel and getting the proverbial egg on my face (Joker picture not-withstanding).  He’s called me out, challenged my geek hood, and sliced / diced my postings (pun intended).  I was going to let this all slide…and then he started using “eh?!” in his postings!!!!  So the gloves are coming off!!!  … Or are they? CubeSet and CubeRankedMember cube formulas are great! For starters, in paying homage to someone who is vastly superior in Excel (I’m sure in other things…

Rate this:

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 3 of 3)

by dennyglee Categories: PowerPivotTags: · 6 Comments

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1.  What is handy about using named sets is that it will only render the top 10 rows as opposed to the millions of rows of users this data set has.  While it is easy to show the Top 10 users, it is not straightforward to filter by those Top 10 users because Excel Named…

Rate this:

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 2 of 3)

by dennyglee Categories: PowerPivotTags: · 6 Comments

Background This blog posting is a continuation of previous post, Create a #PowerPivot report filtered by the Top X Users by (Part 1 of 3), where I had created an Excel Named Set based on the Top 10 Users by Events as noted in Figure 1.  What is handy about using named sets is that it will only render the top 10 rows as opposed to the millions of rows of users this data set has. Figure 1: Top 10 Users by Events using an Excel  Named Set While it is easy to show the Top 10 users, it is…

Rate this:

Create a #PowerPivot report filtered by the Top X Users by <Logic> (Part 1 of 3)

by dennyglee Categories: PowerPivotTags: · 12 Comments

Background I was recently working with a customer to help them solve an interesting PowerPivot problem where they had wanted to get the Top 10 users within their data set and create reports based on that.  One approach is to create a rank function within PowerPivot as noted in a Rank function thread on the SQL Server 2008 R2 PowerPivot for Excel forum?  Another way is to create a Pivot Table where the UserID was placed in the [rows] and the measure in question in the [data] area; and sort the data from largest to smallest. Figure 1: Events by…

Rate this: