SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Archives: September 2010

Knight's Microsoft Business Intelligence 24-Hour Trainer released

Today the much awaited Knight's Microsoft Business Intelligence 24-Hour Trainer book was release.  In this book you will learn about the entire Microsoft BI stack from a bunch of experts that work with me (Brian Knight, myself, Adam Jorgensen, Patrick LeBlanc, and Mike Davis).… Read more

0 comments, 952 reads

Posted in Devin Knight on 28 September 2010

SSAS - Defining Attribute Relationships in 2005 and 2008

Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.  The benefits of creating attribute relationships are multifold.  It can reduce storage space, speed up processing time, improve query performance, and allow usage of member properties. 

So how do attribute relationships work?  The simplest… Read more

0 comments, 1,580 reads

Posted in Devin Knight on 20 September 2010

MDX Aggregate Named Set Than Others

In this quick post I wanted to provide some code that's been useful to me recently.  This MDX statement creates a named set of the Top 20 products and then aggregates on a selected measure.  Commonly though you may want to return an aggregation on those Top 20 products but… Read more

0 comments, 2,365 reads

Posted in Devin Knight on 17 September 2010

MDX - Calculating the Percent of a Named Set

Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic is needed to be built in.  In this example a named set has been added and the requirement is to bring back the top 10 product sales and display the… Read more

0 comments, 1,099 reads

Posted in Devin Knight on 8 September 2010

Creating a PerformancePoint 2010 Data Source

In a previous post I wrote about getting started with PerformancePoint 2010.  In that post you learned about what PerformancePoint is and where to open in in SharePoint 2010.  Your next steps are to configure PerformancePoint which you can find a good guide on TechNet for.  Some of these steps… Read more

0 comments, 890 reads

Posted in Devin Knight on 1 September 2010