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
Author: devinknight
SSIS – Inferred Member Insert in Fact Table Load
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
PowerPivot – Commonly Used DAX Expressions
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
PowerPivot – Creating KPIs
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
PowerPivot – Perspectives
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
PowerPivot – Creating Hierarchies
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
Modified Insert Unknown Row to Dimension Table
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
PowerPivot – Diagram View
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
PowerPivot – Measure Grid
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
SSAS – Understanding KeyColumns Dimension Property
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
SSAS – Creating and Using a Writeback Measure Group
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
SSAS – Using Dimension OrderBy AttributeKey
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
SSAS – Measures or Attributes in Multiple Display Folders
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
Passing Values into an SSIS Package at Runtime from Outside the Package
SSIS provide several methods for passing values into your packages at runtime. The benefit of doing so allows you to change the results of the
Devin Knight 