Planning: Calculation Script Must be Executed Two Times to Get Correct Value in Smartview

(Doc ID 2337068.1)

Last updated on DECEMBER 14, 2017

Applies to:

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

Symptoms

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.

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