Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Null value on using Hyperion Essbase Excel Add-in

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-01-2012
Member
 
Join Date: Jan 2012
Posts: 27
Null value on using Hyperion Essbase Excel Add-in

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?

Reply With Quote
  #2  
Old 21-01-2012
Member
 
Join Date: May 2011
Posts: 410
Re: Null value on using Hyperion Essbase Excel Add-in

In Essbase | Options | Display, use '=0' (without quotes) to replace #MISSING. When you retrieve, 0 will be numeric. Or else refer to the following doc below which will guide you in detail for the entire process.

Hyperion Essbase Spreadsheet Add-in for Excel
Reply With Quote
  #3  
Old 21-01-2012
Member
 
Join Date: Aug 2011
Posts: 690
Re: Null value on using Hyperion Essbase Excel Add-in

Unless things have changed with their latest version, VBA is the only practical solution. 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.
Reply With Quote
  #4  
Old 21-01-2012
Member
 
Join Date: Nov 2010
Posts: 502
Re: Null value on using Hyperion Essbase Excel Add-in

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. Try using "(0)" instead of "0". Excel and the Add-In should interpret it as a true zero.
Reply With Quote
  #5  
Old 21-01-2012
Member
 
Join Date: Nov 2010
Posts: 420
Re: Null value on using Hyperion Essbase Excel Add-in

Oracle Hyperion Essbase (E Spreadsheet Xtended Data Base) is an engine of multidimensional database type MOLAP. Essbase is very appreciated by the financial departments, branches of management control and reporting, particularly in the context of simulation exercises (budget, planning, forecast). The power of Essbase also lies in its opening through a multitude of APIs, tools of analysis or embedded solutions developed by many publishers.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Null value on using Hyperion Essbase Excel Add-in"
Thread Thread Starter Forum Replies Last Post
Hyperion Smart View Add-in not working properly in Microsoft Excel Eas!war MS Office Support 2 31-12-2013 04:49 PM
How to replace a null string with blank cell in Microsoft Excel Eas!war MS Office Support 2 15-02-2012 05:52 PM
How to Check Null Value in C#? sivaranjan Software Development 4 04-02-2010 04:49 AM
What is null value? Swati Software Development 3 14-02-2009 04:39 PM
Handling NULL in ASP.NET Techie Software Development 3 21-09-2005 06:16 PM


All times are GMT +5.5. The time now is 06:58 PM.