Essbase 21c: Cannot Execute A Calc Script Via Excel VBA Function if the Calc Script Contains a POV RUNTIMESUBVAR
(Doc ID 2916610.1)
Last updated on DECEMBER 22, 2022
Applies to:
Hyperion Essbase - Version 21.3.2.0.0 and laterEssbase for OCI Marketplace - Version 21.2.2.0.0 Marketplace and later
Information in this document applies to any platform.
Symptoms
Unable to get the Smart View VBA function HypExecuteCalcScript() to run successfully if calc script contains a POV runtime subvar. It fails on Sample Basic also. If launching the calc script manually in Smart View via the menu it is successful. HypExecuteCalcScript() works successfully on a normal calc script if it doesn't contain the POV subvar e.g. default.
VBA return code = 4
“SS_ERR_ERROR”
“An error specific to the data provider or a generic error that cannot be mapped to a value.”
ERROR IN JOB CONSOLE
---------------------------
The Essbase Jobs console shows this in the error message:
Error parsing formula for [POV, at or after line: ["Fix(POV, Jan, Cola, "New York""]] (line 16): invalid object type;
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |