Start a conversation Sign in
Start a conversation
  1. Concentric Solutions Ltd
  2. Source Default Category
  3. Source Default Folder

Cells with No Data display as NA instead of a value of zero in a Hyperion Retrieve for Reporting (CDA Retrieve) spreadsheet


Cells with No Data display as NA instead of a value of zero in a Hyperion Retrieve for Reporting (CDA Retrieve) spreadsheet
  Modified 08-JUL-2010     Type PROBLEM   

Applies to:

Hyperion Enterprise

Symptoms

Cells with No Data display as NA instead of a value of zero in a Hyperion Retrieve for Reporting (CDA Retrieve) spreadsheet
CDA Retrieve returns # value when there is no data in the database
Formula cells in CDA Retrieve display #N/A instead of zeros

Cause

Hyperion Enterprise Reporting Configuration ,ini file settings missing or not set correctly.

Solution

Add the MissingValues=1 statement to the [MAIN] section of the HDCDARET.ini.
1. Open the HDCDARET.ini file in Notepad and create a [MAIN] section. 
2. Add the MissingValues=1 and save the file to display 0 for cells with no data. 
If an HDCDARET.ini does not already exist, change the POV in the Hyperion Retrieve for Reporting (CDA Retrieve) spreadsheet. This will create the HDCDARET.ini file. (This file is located in the Windows operating system directory.) 

Other Entries:

MissingValues=0 Displaying an N/A for cells for which there is no data, and ERR for cell errors in the worksheet.
MissingValues=1 Displaying a 0 for no data, and ERR for cell errors in the worksheet.
MissingValues=2 Displaying a 0 in cells for which there is no data, and a 0 for cell errors in the worksheet.
Choose files or drag and drop files
Was this article helpful?
Yes
No

  1. GKontos

  2. Posted

Comments