PBCS/ EPBCS: Unable To Export Data to File
(Doc ID 2636154.1)
Last updated on JULY 27, 2023
Applies to:
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
User is trying to extract the data from Budget data to flat file, user is getting below error message:
Cannot calculate. Essbase Error(1012089): Syntax Error in DATAEXPORTCOLHEADER option. Please provide a valid dense dimension name to be used as the column header
There is no Dimension called "Period", I have Dimension called "Periods" and it is a Dense dimension.
According to Log the DATA EXPORT Script is:
SET DataExportOptions
{
DATAEXPORTCOLFORMAT ON;
DATAEXPORTDIMHEADER ON;
DATAEXPORTDRYRUN OFF;
DataExportRelationalFile OFF;
DataExportNonExistingBlocks OFF;
DataExportLevel ALL;
DATAEXPORTCOLHEADER "Period";
DATAEXPORTOVERWRITEFILE ON;
DataExportDynamicCalc OFF;
};
FIX (@Relative("Account",0),@Relative("Currency",0),@Relative("Entity",0),"Budget","Working","FY19",@Relative("Cost Center",0),"No Details",@Relative("Project",0),[Dimension member],@Relative("Periods",0),"Jan")
DATAEXPORT "File" "," "/u03/inbox/data/planfile.txt" "#";
ENDFIX
NOTE: The system is incorrectly using Dimension name "Period" instead of "Periods"
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |