DATAEXPORT is not exporting numbers on level0 member, it's exporting the same numbers on parents.
We are using dataexport command in our calc to export level0 data to feed ASO cube. The process ignores some of the level0 members data and report the same data into their parent.
We user dataexport command with following options :
SET CACHE HIGH;
SET LOCKBLOCK HIGH;
SET DATAEXPORTOPTIONS{
DataExportLevel "LEVEL0";
DataExportRelationalFile ON;
DataExportOverwriteFile ON;
};
FIX ("Y2021","Actual", @RELATIVE("Customer",0), "Calc", @UDA("Time", "CLOSED_ACTUAL"), @REMOVE(@RELATIVE("Accounts",0),@LIST( "Rates" , @SHARE( @DESCENDANTS ("Accounts") ) ) ));
DATAEXPORT "File" "," "/u02/cgadta/DD.XX.FINAL.txt";
ENDFIX;
Following is the snippet of Customer hierarchy :
PR(CL1)->6044888(CL2)->6044676(CL3)->6066832(CL4)->6023344(CL5)->6001231(CL6)