Page 1 of 1
Is the Excel IF formula blocking the write back function of DBRW?
Posted: Wed Dec 08, 2021 4:38 pm
by 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?
Re: Is the Excel IF formula blocking the write back function of DBRW?
Posted: Wed Dec 08, 2021 5:07 pm
by Wim Gielis
Try to nest the IF within the DBRW ?
Re: Is the Excel IF formula blocking the write back function of DBRW?
Posted: Thu Dec 09, 2021 7:57 am
by 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?
Re: Is the Excel IF formula blocking the write back function of DBRW?
Posted: Thu Dec 09, 2021 10:18 am
by 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!