My Oracle Support Banner

During The DATAEXPORT From Essbase The Single Quote (') Is Surrounded By One Other Single Quote (Doc ID 1970315.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

During the DATAEXPORT from Essbase (via Calculation Script) the single quote (') is surrounded by one other single quote becoming a double-single quote ('').

This causes the error "member not found" when importing the data back into Essbase.

Example of Calc script used to export:

//ESS_LOCALE English_UnitedStates.Latin1@Binary

SET CALCPARALLEL 5;
SET CALCTASKDIMS 2;
SET AGGMISSG ON;
SET UPDATECALC ON;

SET DATAEXPORTOPTIONS
{
DataExportColFormat ON ;
DataExportOverwriteFile ON;
DataExportColHeader Scenario;
DataExportDimHeader ON;
DATAEXPORTRELATIONALFILE ON;
};

/*Export */
FIX(@RELATIVE("Year",0),@RELATIVE("Measures",0),"Actual",@RELATIVE("Market",0),@RELATIVE("Product",0))
DATAEXPORT "file" "," "C:\Users\svchypdcom\Desktop\Export\Export_file.txt"
ENDFIX

Export content: Export_file.txt
"100-10 '' modified","New York '' modified","Sales ' modified"," Jan ' modified ",10

 

Changes

no changes

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.