Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why am I getting "#N/A"?
I'm using the Excel plug in for Hyperion software, and when I grab data from
a portion of the database that's empty, I get #N/A-- I'd like it to display as zero. Is there a setting in Excel or a toolpak that will make what is essentially "no data" appear as zero, rather than this error? (I never had this problem in 5 years of working with the same Hyperion software and data, but just got upgraded to an XP machine with Excel 2003) Thanks, Marc |
#2
|
|||
|
|||
Hyperion is the company. I'm guessing you mean Essbase:
Try this from the main menu: EssbaseOptionsGlobal #Missing Label: Set to 0 (<-zero) Does that help? -- Regards, Ron |
#3
|
|||
|
|||
Actually, it's Hyperion Enterpise. I don't see an option like this in
Enterprise, but perhaps that's because I don't have administrator rights. I'll check with my administrator. The problem doesn't show up on my old pc, which was Windows 2000 Pro, using Excel 2000 (same version of Hyperion Retrieve). I was hoping there was a setting in my new XP machine (either somewhere in XP, or in Excel 2003) that would resolve this. There are still other users on my network running Excel 2000, so I'd like to avoid a change to the system we are all sharing. Does this ring a bell for anyone? Thanks, Marc "Ron Coderre" wrote in message ... Hyperion is the company. I'm guessing you mean Essbase: Try this from the main menu: EssbaseOptionsGlobal #Missing Label: Set to 0 (<-zero) Does that help? -- Regards, Ron |
#4
|
|||
|
|||
I got a solution to this problem from the Hyperion help desk. Turns out it
was a setting in the new install that was not correct. Thanks for the help anyway! "Marc Bobrow" wrote in message ... Actually, it's Hyperion Enterpise. I don't see an option like this in Enterprise, but perhaps that's because I don't have administrator rights. I'll check with my administrator. The problem doesn't show up on my old pc, which was Windows 2000 Pro, using Excel 2000 (same version of Hyperion Retrieve). I was hoping there was a setting in my new XP machine (either somewhere in XP, or in Excel 2003) that would resolve this. There are still other users on my network running Excel 2000, so I'd like to avoid a change to the system we are all sharing. Does this ring a bell for anyone? Thanks, Marc "Ron Coderre" wrote in message ... Hyperion is the company. I'm guessing you mean Essbase: Try this from the main menu: EssbaseOptionsGlobal #Missing Label: Set to 0 (<-zero) Does that help? -- Regards, Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|