essbase calc output

@RELATIVE("Nominals"

HI Essbase Gurus,

Scenario: Tried to export input data from 2 cubes but the format is different

First script output in the required format

//ESS_LOCALE English_UnitedStates.Latin1@Binary

SET DATAEXPORTOPTIONS

{

DataExportLevel INPUT;

DataExportRelationalFile ON;

DATAEXPORTNONEXISTINGBLOCKS ON;

};

/*FIX (@RELATIVE("Nominals",0)) */

fix(@REMOVE(@relative("Nominals",0),@descendants("Percentages")))

Fix("Y2018")

FIX( @descendants("jan",0))

FIX(@RELATIVE("BA",0))

FIX(@RELATIVE("Company",0))

FIX(@RELATIVE("CostCodes",0))

     DATAEXPORT "File" " "  "14SEPDABUD2018JAN7.txt";

ENDFIX;

ENDFIX;

ENDFIX;

ENDFIX;

ENDFIX;

ENDFIX;

output format:

Second cube script:

SET DATAEXPORTOPTIONS

{

DataExportLevel input;

DataExportRelationalFile ON;

DATAEXPORTNONEXISTINGBLOCKS ON;

};

/*FIX (@RELATIVE("Nominals",0)) */

fix(@REMOVE(@relative("Nominals",0),@descendants("Percentages")))

Fix("Y2018")

FIX( @RELATIVE("JAN",0))

FIX(@RELATIVE("Target"