My Oracle Support Banner

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 and later
Essbase for OCI Marketplace - Version Marketplace and later
Information in this document applies to any platform.


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
“An error specific to the data provider or a generic error that cannot be mapped to a value.”

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;


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.