Issue with data export via Data Management
Content
Hi All,
We are trying to export data via data management, we are getting the following error message:
2021-08-23 15:02:49,604 ERROR [AIF]: Cannot calculate. Essbase Error(1012089): Syntax Error in DATAEXPORTCOLHEADER option. Please provide a valid dense dimension name to be used as the column
Please see below for the script in the log file:
{
DATAEXPORTCOLFORMAT ON;
DATAEXPORTDIMHEADER ON;
DATAEXPORTDRYRUN OFF;
DataExportRelationalFile OFF;
DataExportNonExistingBlocks OFF;
DataExportLevel ALL;
DATAEXPORTCOLHEADER "Period";
DATAEXPORTOVERWRITEFILE ON;
DataExportDynamicCalc ON;
DataExportPrecision 2;};
It seems that by default the period dimension is picked as the DATAEXPORTHAEDER, however for our client the period dimension is not Dense.
Is there an option to change the DATAEXPORTHAEDER dimension in the data management? We already tried to pivot an other dense dimension, but this doesn't do the work.