Hyperion SmartView With Excel VBA Fails With Error Code 2147467259

(Doc ID 1967629.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Hyperion Essbase - Version 11.1.2.3.502 and later
Information in this document applies to any platform.

Symptoms

Combination:

Hyperion Planning version - 11.1.2.3.500
Essbase Server version - 11.1.2.3.502
Hyperion Provider Services - 11.1.2.3.502
Hyperion SmartView - 11.1.2.5.210

 

With custom excel based report with VBA code linked to Smartview, you may get the error:

"Error while deleting data from Essbase: Automation error Unspecified error" - Error code 2147467259

when trying to delete the budget data from a cell.

Changes

recent upgrade from Hyperion Planning 11.1.1.3.x to new version 11.1.2.3.500

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms