Exporting Hyperion essbase Data

@RELATIVE("Nominals"

Hi Gurus,

There is a Scenario to export Hyperion  data in row format to import in to an oracle database table where columns are static, but in hyperion export we will have different collums as jan got 31 days and feb got 28 days and so on

Dimension:

Nominals(Dense)

Year Sparse

Period ( with day level info) Dense

Company Sparse

Scenario Sparse

Costcodes Sparse

When export using

SET DATAEXPORTOPTIONS

{

DataExportLevel INPUT;

DataExportRelationalFile Off;

Dataexportcolformat off;

DATAEXPORTNONEXISTINGBLOCKS ON;

};

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

Fix("Y2018")

FIX(@ICHILDREN("jan"))

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

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

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

     DATAEXPORT "File" " " "JanDABUD20185xt";

ENDFIX;

ENDFIX;

ENDFIX;

ENDFIX;