-
Recent Posts
Recent Comments
Archives
- April 2013
- November 2012
- February 2012
- January 2012
- December 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
Categories
Meta
Monthly Archives: April 2008
Renaming the Script Project in SSIS 2008
I found something interesting in SSIS 2008 today, and thought I’d share it. I was working with David Darden on a package that included a script task. In 2008, the Visual Studio Tools for Applications (VSTA) environment is used to … Continue reading
Posted in Uncategorized
Comments Off
MDX Filters in PPS Monitor
I had a question on how to implement MDX Filters in PerformancePoint Monitor awhile back. Nick Barclay provided an answer here. Some samples Nick provided were: 1: [Time].[Fiscal Year].Children and 1: DESCENDANTS( 2: [Geography].[Geography].[All Geographies] 3: ,[Geography].[Geography].[Country] 4: ,SELF_AND_BEFORE) Depending … Continue reading
David Darden’s Blog
One of my colleagues, David Darden, has started blogging on www.agilebi.com. He’s been working with the Microsoft BI stack for several years now, and has a lot of great knowledge to share. His first post is on using the PerformancePoint … Continue reading
Posted in Uncategorized
Comments Off
Creating a Scorecard Transform in PerformancePoint Server Monitor
Overview I’ve spent a couple of days doing some prototyping around PerformancePoint Monitor… there have been a few things that I’ve wanted to accomplish, so when the PerformancePoint Monitoring SDK was released, it seemed like the way to do it. … Continue reading
Posted in Uncategorized
Comments Off
Common Expressions In the Data Flow
I use the Derived Column transform in the Data Flow a lot. In fact, I can’t remember the last time I wrote a production package that didn’t include at least one Derived Column transform in it. Over time, I’ve built … Continue reading
Posted in Uncategorized
Comments Off
Sending an Alert if a Package Runs Too Long
A question that has come up in a few different situations recently is how to send someone an alert if your package is taking too long to execute. For example, you might have a package that loads a large number … Continue reading
Posted in Uncategorized
Comments Off