How to export Data from EPBCS at dimension level or at a required parent\top level members in a dim.
Summary:
How to export Data from EPBCS at dimension level or at a required parent\top level members in a dim
Content (please ensure you mask any confidential information):
we are working on data export using rules,
see the sample scripts
SET DATAEXPORTOPTIONS
{
DataExportLevel ALL;
DataExportDynamicCalc OFF;
DataExportNonExistingBlocks OFF;
DataExportDecimal 4;
DataExportColFormat ON;
DataExportColHeader "Period";
DataExportDimHeader OFF;
DataExportRelationalFile OFF;
DataExportOverwriteFile ON;
DataExportDryRun OFF;
};
FIX(
C1,
ActFcst,
working,
Units,
CUSD,
FY24,
"MGDHotel",
"Load/Calc",
"IC",
"Operating Profit",
F7762,
Jan
)
DATAEXPORT "File" "," "/u03/lcm/test.txt";
ENDFIX
in the above script we are trying to extract data at Operating Profit (Gen 3 memebr under Account dimension and its a dynamic calc memebr).