EVDRE reporting not stable: "hiding columns" & applying datarange formula"

[Former Member]

Hi,

we use BPC 5.1. (SP6) With several EVDRE reports we experience that our excell session sometimes stops working, typically when changing the CV and expanding again. At the bottom of the excell we see the statements:

"hiding columns" or also "applying datarange formulas".

I wait for more than 10 minutes, but nothing changes and I can't do anything anymore and have to abort excell with CTRL + ALT + DEL ...

Does anyone experience the same problems? (We work with Office 2007)

regards

Dries

[MIH6]

Did you try to make a similar test in ApShell (means same range, same formulas)?

Did you encounter the same issue?

[MIH6]

Hi,

Does it happen only to a specific report?

Are you able to test the same behaviour using a client with Excel 2003?

How many members the expand should display?

Best regards,

Mihaela

[Former Member]

Hi,

I cannot test with Office 2003 since I don't have it installed ..., I typically have it with EVDRE reports, not with schedules created from a template. Numbers of members to be expanded, maximum 10, for which 10 accounts are displayed (so max 100 lines) ... We do not have many data in our system yet, lets say 20.000 records max.

D