Knowledgebase: Enterprise
Cells with No Data display as NA instead of a value of zero in a Hyperion Retrieve for Reporting (CDA Retrieve) spreadsheet
Posted by Priya Doyle on 16 February 2011 11:26 AM

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.


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: