I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to set the stage for what
PASS Summit is quickly approaching and while many of you are registering I wanted to remind you of some of the great Pre Conference seminars
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into this article on SQL Server
Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used DAX Expressions. You can register
Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot has made what was once
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split up your cube so users can
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies are useful because it allows
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. This is a great script
The new “Denali” PowerPivot has a lot of fanatic new additions that I’ve really been looking forward to. Many of my biggest complaints from the
There are a lot of fantastic new features in the latest CTP 3 release of PowerPivot, which you can download here. This is a huge
For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to them. However, I’ve found for
Imagine you have spent the last 9 months developing a sales Data Warehouse and an Analysis Services cube. Your end users love what you have
Often when building dimensions there is a need to order you dimension attributes by something other than the NameColumn or KeyColumn properties. An example of
I had a client recently show me a neat little tip that I thought I would share. In the cube he was designing he had
Devin Knight 