| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperion Essbase Excel Add-in - returning text ("0") for null valu
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? Thanks ... bill morgan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperion Essbase Excel Add-in - returning text ("0") for null valu
The short answer is: no.
Unless things have changed with their latest version, VBA is the only practical solution. *********** Regards, Ron XL2002, WinXP-Pro "bill_morgan" wrote: 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? Thanks ... bill morgan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperion Essbase Excel Add-in - returning text ("0") for null
Well ... at least I picked the right solution. Thanks for the confirmation.
Seems unusual that there isn't some function on the cube side like T-sql convert() or cast() that could be applied to all data retrievals. "Ron Coderre" wrote: The short answer is: no. Unless things have changed with their latest version, VBA is the only practical solution. *********** Regards, Ron XL2002, WinXP-Pro "bill_morgan" wrote: 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? Thanks ... bill morgan |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperion Essbase Excel Add-in - returning text ("0") for null
In Essbase | Options | Display, use '=0' (without quotes) to replace
#MISSING. When you retrieve, 0 will be numeric. "bill_morgan" wrote: Well ... at least I picked the right solution. Thanks for the confirmation. Seems unusual that there isn't some function on the cube side like T-sql convert() or cast() that could be applied to all data retrievals. "Ron Coderre" wrote: The short answer is: no. Unless things have changed with their latest version, VBA is the only practical solution. *********** Regards, Ron XL2002, WinXP-Pro "bill_morgan" wrote: 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? Thanks ... bill morgan |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperion Essbase Excel Add-in - returning text ("0") for null
Which versions of Essbase/Excel does that work for?
After changing the #Missing Label to: =0 I get =0 as text in the cells, instead of the expected numeric zero. That occurs regardless of the numeric format of the impacted cells. *********** Regards, Ron XL2002, WinXP "themediumtee" wrote: In Essbase | Options | Display, use '=0' (without quotes) to replace #MISSING. When you retrieve, 0 will be numeric. "bill_morgan" wrote: Well ... at least I picked the right solution. Thanks for the confirmation. Seems unusual that there isn't some function on the cube side like T-sql convert() or cast() that could be applied to all data retrievals. "Ron Coderre" wrote: The short answer is: no. Unless things have changed with their latest version, VBA is the only practical solution. *********** Regards, Ron XL2002, WinXP-Pro "bill_morgan" wrote: 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? Thanks ... bill morgan |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hyperion Essbase Excel Add-in - returning text ("0") for null
I'm currently using the 7.1 version of the Excel Add-In, and it works for us.
What version are you using, that it is not working? "Ron Coderre" wrote: Which versions of Essbase/Excel does that work for? After changing the #Missing Label to: =0 I get =0 as text in the cells, instead of the expected numeric zero. That occurs regardless of the numeric format of the impacted cells. *********** Regards, Ron XL2002, WinXP "themediumtee" wrote: In Essbase | Options | Display, use '=0' (without quotes) to replace #MISSING. When you retrieve, 0 will be numeric. "bill_morgan" wrote: Well ... at least I picked the right solution. Thanks for the confirmation. Seems unusual that there isn't some function on the cube side like T-sql convert() or cast() that could be applied to all data retrievals. "Ron Coderre" wrote: The short answer is: no. Unless things have changed with their latest version, VBA is the only practical solution. *********** Regards, Ron XL2002, WinXP-Pro "bill_morgan" wrote: 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? Thanks ... bill morgan |
|
#7
|
|||
|
|||
|
Quote:
|
|
#8
|
|||
|
|||
|
HI all,
Thank you.. my version is 11.1.2 and it works!!!! sparkeye Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| How can I wrap text in a text box in Excel? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
