BPC Microsoft v10.1 Dimension Member Row Limits

[baxman]

Hi,

We have been an organization which continues to grow year after year, and the size of the dataset, and some of the new functionality in sub systems that we integrate our BPC v10.1 MS application with, may now require us to take one of our Dimensions and increase the member id count from 15-20k, to 100-150k rows (Unique Member ID's, with 1 additional Hierarchy that already exists.).

I've read several articles which recommend best practices around dimension members, hierarchies, and properties. Assuming the only item we change is the number of rows (not adding new hierarchies, or properties) are other customers able to have consistent good performance with dimensions of this size, with things like:

1. Running of Daily/Nightly Scripts
2. User Login Performance (Retrieving/Submitting Data)
3. Overall Navigation/Use within the front end Excel Add In
4. Overall Navigation/Use of the Admin Console features
5. Other things to consider? (We run Full Optimizations Daily as well in all Models, and our Fact Tables have approximately 60-80 Million Records)

Thank you in advance!

Brian