debug EVDRE

[Former Member]

I've a workbook with 5 worksheets. While doing 'Expand All' it gets stuck at one of the worksheets with following information: "EVDRE - Applying DataRange Formula....". After that it doesn't do anything.

Does anyone know how to debug EVDRE ?

Thanks, John

[Former Member]

As Daniel said the only way is to execute step by step the five expansions and he explained a good way to do it. The messages of execution will appear in the position where you have the =evdre() formula, it is interesting to check that point. You have also a log file that can maybe retrieve somo more information under the folder BPC\logging.... Check any conflict of formats or cross references in the creation of the format. Evdre is compiled and cannot be debugged itself. .

Good luck.

Philippe

[Former Member]

Hi.

Have you tried to expand the individual EVDREs to see if they work as "Standalone" I could be possible that one of them is corrupt.

I know it can be impossible to do so if the evdre's are referncing each other but if that is not the case try to expand then step by step.

To do so just disable the EVDRE's by putting an ' sign before the formula to store them as a text.

One other question: Do you have any VBA Code running in the Input Schedules?

Daniel

[Former Member]

I find that performance is a lot better if you don't use EVDRE formatting at all. Just remove the link to the cell range and use Excel formatting instead

Regards

[Former Member]

look at BW transaction slg1 and object UJ* ... the dumpdatacache does not work for BPC NW ...

D

[ssandepogu]

Hi,

For how much time is it getting stuck? Once its gets stuck then are you closing the BPC for Excel through task manager? Since you are saying you are expanding 5 sheets at once so it might take little time to show the results if you are sheets are interlinked and are complex.

But if its getting stuck forever then I would suggest you to check the logging folder as suggested by above colleague both on Local machine and on .NET server too. Also if you have access to ABAP system, try checking the SLG1 for application logs to see if you can get some clue.

Thanks

[Former Member]

we are also facing the same issue.

Any clue how to solve it

[Former Member]

hi,

perhaps activate option DumpDataCache in the EVDRE OptionRange :

then the content of the data cache is written in the logfile EvDre_log.txt (on your local computer).

perhaps also checking the logfiles on your server (C:/BPC/logging)

D