During The DATAEXPORT From Essbase The Single Quote (') Is Surrounded By One Other Single Quote
Last updated on MAY 01, 2018
Applies to:Hyperion Essbase - Version 126.96.36.199.503 and later
Information in this document applies to any platform.
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:
SET CALCPARALLEL 5;
SET CALCTASKDIMS 2;
SET AGGMISSG ON;
SET UPDATECALC ON;
DataExportColFormat ON ;
DATAEXPORT "file" "," "C:\Users\svchypdcom\Desktop\Export\Export_file.txt"
Export content: Export_file.txt
"100-10 '' modified","New York '' modified","Sales ' modified"," Jan ' modified ",10
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