Tuesday, March 29, 2011

PerformancePoint Planning limitations

For those of you (like me) with customers still using PerformancePoint 2007 Planning, there are some limitations to be aware of.

http://social.technet.microsoft.com/forums/en-us/ppsplanning/thread/12A9AD9D-BF5F-4A28-98CD-7827AC75C061

It has nothing to do with how many dimensions there are in a model.



It has everything to do with how many dimensions are in a model site, how many models are in a model site, and how many member sets are in a dimension. It seems that if you add all dimensions, all hierarchies, and all models in a model site they cannot exceed 128 or else you get this error.

The staging database contains a table which can assist to ensure that these limits aren't exceeded.

select * from fk_relationships where scope =

No comments: