Results 1 to 5 of 5

Thread: Null value on using Hyperion Essbase Excel Add-in

  1. #1
    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?

  2. #2
    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

  3. #3
    Join Date
    Aug 2011
    Posts
    695

    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.

  4. #4
    Join Date
    Nov 2010
    Posts
    503

    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.

  5. #5
    Join Date
    Nov 2010
    Posts
    422

    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.

Similar Threads

  1. Replies: 2
    Last Post: 31-12-2013, 04:49 PM
  2. Replies: 2
    Last Post: 15-02-2012, 05:52 PM
  3. How to Check Null Value in C#?
    By sivaranjan in forum Software Development
    Replies: 4
    Last Post: 04-02-2010, 04:49 AM
  4. What is null value?
    By Swati in forum Software Development
    Replies: 3
    Last Post: 14-02-2009, 04:39 PM
  5. Handling NULL in ASP.NET
    By Techie in forum Software Development
    Replies: 3
    Last Post: 21-09-2005, 06:16 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,700,556.14177 seconds with 17 queries