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
SymptomsCells 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
CauseHyperion Enterprise Reporting Configuration ,ini file settings missing or not set correctly.SolutionAdd 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
|