Hyperion Enterprise Retrieve Displays #VALUE with HPVAL Formula
Posted by Priya Doyle on 15 February 2011 05:27 PM
|Hyperion Enterprise Retrieve Displays #VALUE with HPVAL Formula|
| ||Modified 11-AUG-2010 Type PROBLEM || |
Applies to:Hyperion Enterprise - Version: 22.214.171.124.00 and later [Release: 5.0 and later ]
SymptomsHyperion Enterprise Retrieve displays #VALUE with HPVAL formula.
The POV settings in Retrieve appear correct
CauseThe actual value in the period option is not the displayed value due to Excel formatting.
Although it appears to be MAR 03 in the formula bar it is really 3/3/04 as an example.
SolutionFrom within Excel, in the cell which references the period, either enter the period number (i.e.1 for Jan Etc) or use the CHANGE PERIOD option from the RHXL menu to populate the period cell with a correctly formatted period value.
Once done refresh the sheet and ensure the values are now displaying as expected.