Monthly Archives: July 2009

PPS Filters: Beware of Changing Keys

The other day I thought it would be fun to arbitrarily change the keys for all the members in one of my dimensions.  Actually, there was a legitimate reason but after the fact I realized there was a much better … Continue reading

Posted in MDX, PPS | Tagged , , | Comments Off

Boost Performance in PerformancePoint Server

I found this and thought I’d pass it on. When implementing a PPS dashboard, the browser of choice should be Internet Explorer 8. Whereas IE7 only supports up to 2 concurrent connections to the server, IE8 supports up to … Continue reading

Posted in PPS | Tagged , | Comments Off

View Permissions for Reporting Services in SharePoint Integrated Mode

Setting up security for SSRS in SharePoint integrated mode can be a bit tricky, particularly if you want to set up some of your users to only be able to run reports, but not to be able to modify or … Continue reading

Posted in Uncategorized | Comments Off

[Double Clicking Bracketed Text in SSMS]

I’m a big fan of SQL Server Management Studio; it’s a really great tool with a tremendous amount of functionality.  Lately I’ve been working in the new 2008 version of SSMS and a few days ago I noticed some peculiar … Continue reading

Posted in SSMS | Tagged , , , | Comments Off