Is the Excel IF formula blocking the write back function of DBRW?

[LGEIS]

I have got an Excel (I am using PAX/PAfE) cell with a DBRW formula encapsulated inside an IF statement and I want to write back data to a target cube from this cell, just by typing it into the cell manually.

When I am using the blank DBRW (=DBRW(...)) formula it works finde, but inside the IF statement ( =IF(A19=1;DBRW(...);"")) it gets overwritten by a bare value and the formula disappears.

Is there an easy workaround for this issue?

[Wim Gielis]

Try to nest the IF within the DBRW ?

[lotsaram]

Your DBRW formulas need to be "clean" in order for Prespectives to recognize that the cell contains a DBRW and take over the cell onChange event.

What is the IF test doing and can it be done differently?

[LGEIS]

I just found a duplicate: viewtopic.php?t=9239

The outline ist, that I cannot write values from a DBRW inside an Excel formula. Taking this into consideration, I had to do some workaround stuff.

My solution is quite simple:

Col1: takes the clean DBRW formula
Col2: is the reference column to a Dimension, which is filled by an IF statement

My problem was, that I had blank cells in column 2 for some conditions. I created a dummy element in the referenced dimension to avoid value error to show up in column 1.

Problem solved!