Another Essbase Excel Add-in question. When I retrieve values into Excel from our Essbase Cube (using Hyperon Excel Add-In), null values return as text characters. Even if I format the cells, these values appear as "0". The only way I can change the text to numbers is through a VBA procedure that changes "0" to value 0 for all cells in the used range. Can anything be done (either on user end or Admin side) to get null to return as number 0 without having to use VBA?
Bookmarks