My Oracle Support Banner

Planning: Calculation Script Must be Executed Two Times to Get Correct Value in Smartview (Doc ID 2337068.1)

Last updated on NOVEMBER 05, 2019

Applies to:

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


You are connecting Essbase application/datasource through Hyperion@Essbase via Smartview. You input numerical values in Smartview and [Submit Data], then Execute Calculation Script to let dimensions be caculated. However, when you refresh data in SmartView, one cell is displayed as [#Missing] instead of correct value. And then you execute Calculation Script again, the [#Missing] cell is displayed as correct value.

You can reproduce this issue like next.

1. Use excel file sheet to connect Essbase application in SmartView.

2. Input date like next.

3. Submit data.

4. Execute the calculation Script from Administration Services Console to let some dimension be calculated.

5. After [Refresh] excel sheet, you will find only one cell is still displayed as #Missing like next.

6. Execute the calculation script again from Administration Services Console and then the value is displayed correctly.


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.