PerformancePoint 2013 Dashboards: Applying Dynamic Security using CustomData and EffectiveUserName

I recently had the great pleasure of solving a PerformancePoint 2013 puzzle and I thought I'd share how I did it to help others and as a reference for my fellow colleagues. Our team was trying to implement dynamic active directory security for PerformancePoint 2013 dashboards. A variety of PerformancePoint web parts were tested as part of this endeavor including Analysis Services scorecards, analytic charts and grids, SSRS reports (native mode), and Excel Services.