Skip to Content
author's profile photo Former Member
Former Member

Recommended number of members

Hi,

what is the recommended maximum number of base members in a single dimension?

Thanks,

Anders

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 01:17 PM

    There is no recommended number of base members. It depends on the needs of the customer. Although under 65K members they can be maintained in the administration console, while above 65K they need to be automatically maintained in SQL server via an SSIS package, which is a little more difficult to setup.

    -Joost

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I am aware of the limitation of 65k members through the admin console and have loaded and processed my members (300k) via a SSIS package but what I need to know is how this affect the performance of the system? I know it is possible to use an unlimited number of members but it seem to affect the perfomance a lot?

  • Posted on Jun 18, 2008 at 02:44 PM

    The 65 k limitation refers to excel limitation or It is an application one. With excel 2007 is there the same limitation?

    Thanks

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 03:09 PM

    65K limitation is for Excel and not for the application. We can load more than 65K memebers and with SP3, even we will should be able to view more than 65K members in the 'maintain dimension members' in multiple worksheets, thereby still within 65K rows per worksheet Excel limit. However it will affect the performance. Also please note that the dimensions are cached on the client.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.