Number of members returned when using EVEXP

[Former Member]

Hi there,

I am trying to build a report using an EVEXP formula, but it keeps giving me an error saying "Expansion exceeds maximum allowed rows".

I have 1720 members in this particular dimension, which isn't THAT many!

Any idea how I can get around this problem? I am using BPC Version 5 SP 7.

Thanks a lot,

Jason

[Former Member · Accepted solution]

Hi,

Go to "set Workbook Option" , Define rows (as per requirement might be 10000) in "Maximum Expansion Limit" option.

You can define the expansion limit for rows and column in this option.

[Former Member · Accepted solution]

Thanks Kapil - it worked!! Not sure why I didn't look there to begin with!

Thanks for your help,

Jason