My Oracle Support Banner

PBCS/ EPBCS: Unable To Export Data to File (Doc ID 2636154.1)

Last updated on MARCH 17, 2020

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.