Planning: Calculation Script Must be Executed Two Times to Get Correct Value in Smartview
Last updated on DECEMBER 14, 2017
Applies to:Hyperion Planning - Version 126.96.36.199.600 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.
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