Blank OLAP Data
Our Cubevalue formula results in a blank where there is no data, we wish this
to show a zero. Under the excel OLAP addin for 2003 the Cubecellvalue
formual returns a zero, because we had the ability in the OLAP options to set
a default for blanks. WHERE HAS THIS GONE?
We have seen the work arround of using ISTEXT but that is not a workable
answer for what was a simple step in 2003
|