SSRS-embedded-in-PPS_Gotcha

In Performance Point, we can create a report that points to an SSRS report, and embed this in our dashboard. The advantage of doing this is the richness of the interaction with other PPS parts, so for instance, being able to click on a scorecard, and have the measure in the report update dynamically.

Very useful, and I'll post an article on how to do this soon.

One gotcha is when testing security in Sharepoint. Sharepoint allows you to change your userID to test as another user.

Unfortunately, as soon as you do this, SSRS loses the session ID, and will throw an error instead of displaying.

It's cute, it means you have to log into the test machine as the user you're testing with.