Google
 

Thursday, August 21, 2008

Train the Trainer - Helpful tricks

I am taking a course in Denver on PerformancePoint Expert Training. The contributions by the attendees to improving knowledge around planning has been even more valuable than the training itself.

I will try and post some of the nuggets here to assist with deployments. (Since I'm in Denver, nuggets sound appropriate to use)

Some are more process-oriented than PerformancePoint specific.

Nugget #1 - Make the cycle a bit longer than the assignment - This provides a grace period.

Nugget #2 - In Modeler, Save and Refresh are your friends. Perform these often.

Nugget #3 - Dimension-level (member level) custom security hits performance in Excel filters and queries, and when directly accessing the cubes. Create a "Please select..." member in each of the dimensions. Use this as the default selection in your reports/input forms that require security. This will make the users select all filters that are security-dependent, and should speed up initial queries.

No comments: