Peter Eb. : HOWTO: Dynamic rows or columns with a dimension property filter

Currency may not change that much, but how about employee or department?

Peter has a way to hack PerformancePoint Planning into using dynamic members.

Then click Validate RDL to make sure there are no syntax errors. Then click ok and the report will be refreshed. Now using the filter should give the same values as the static selection, but when a new currency member is added with a new value for the property MemberName it will automatically appear in this list. Voila! Not so simple, but not so hard.

Peter Eb. : HOWTO: Dynamic rows or columns with a dimension property filter

What would be nice is to see an example of a web-based or Excel-based data entry solution for adding members to the model.

Something like this:

http://www.oraxcel.com/projects/sqlxl/

or this

http://msdn.microsoft.com/en-us/library/aa203746(office.11).aspx

or this

http://www.perlielab.com/CallistoPages/datamanager.html

or how about creating a SQL job on the server that polls published spreadsheets or Sharepoint lists for data and loads them into the staging & app databases and processes the model?

This would allow for things like headcount planning and adding new products or customers to a model without modeler permissions.

Sounds like a lot of work for something that should really be in the add-in as a feature (member management).

Perhaps Microsoft MDM will incorporate this feature into PerformancePoint and/or Excel?

At least that's what the roadmap tells us...