DataExport Works Differently between Essbase Versions 11.1.2.2. and 11.1.2.4 (Doc ID 2123909.1)

Last updated on APRIL 07, 2016

Applies to:

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

Symptoms

After migrating to Essbase v11.1.2.4.x from v11.1.2.2.x, some of the DataExport options set in a calc script do not work. For example, exporting data using this set of DataExport options:

On v11.1.2.2 gave the result:

OK/INFO - 1012698 - This DataExport operation will export data from existing blocks only. Any FIX on sparse dynamic calc members will be ignored. Use DATAEXPORTNONEXISTINGBLOCKS ON option to export data from all potential blocks..
OK/INFO - 1012690 - Data Export Completed. Total blocks: [2705]. Elapsed time: [972.51]..
OK/INFO - 1012696 - Total Number of Non-Missing cells exported: [72109]..
OK/INFO - 1012550 - Total Calc Elapsed Time : [972.51] seconds.
OK/INFO - 1013274 - Calculation executed.

After migration to v11.1.2.4, no data is exporting:

OK/INFO - 1012698 - This DataExport operation will export data from existing blocks only. Any FIX on sparse dynamic calc members will be ignored. Use DATAEXPORTNONEXISTINGBLOCKS ON option to export data from all potential blocks..
OK/INFO - 1012690 - Data Export Completed. Total blocks: [0]. Elapsed time: [0.58]..
OK/INFO - 1012696 - Total Number of Non-Missing cells exported: [0]..
OK/INFO - 1012550 - Total Calc Elapsed Time : [0.582] seconds.
OK/INFO - 1013274 - Calculation executed.

 

 

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