BPC 7M SP4 EVDRE missing rows - Error is "1004-Selection is too large.}

[Former Member]

Hello,

On a customer who installed BPC 7 Ms SP4 I have on client Exception log the error:

===================[System Error Tracing]=====================

[System Name] : BPC_ExcelAddin

[Job Name] : clsExpand::applyDataRangeFormula

[DateTime] : 2009-07-17 09:44:13

[Exception]

Detail<sg : {1004-Selection is too large}

===================[System Error Tracing End ]=====================

When I see this error there is an EVDRE input schedule expanding which have some of the rows missing rows descriptions.

This means there is a gap of missing row header formulas stating from second row to somewhere in the middle of the report.

If I reduce the number of the resulting rows for the same EVDRE input schedule results are ok.

Do you know some setting to fix this?

I tried increasing the Maximum Expansion Limit for rows and columns in Workbook Options without success.

Thank you.

[romuald_colletaz]

Hi all,

I have the same problem with 7.0MS SP07. With 59 expanded members it works. With 60 expanded members it fails.

Mihaela, could you explain us what is the purpose of the parameters you talk about?

thanks,

Romuald

[i045436]

Hi,

Please try to add in your tblDefaults(sql table for your appset) the following line:

Userid = _INTERNAL

Type = SYSTEM

App =

Keyid = DO_COMPRESS

Value = 0

Best regards,

Mihaela