martes, 1 de abril de 2014

Essbase: Exporting Data with Calc Script

SET UPDATECALC OFF;
SET DATAEXPORTOPTIONS
 {
 DataExportLevel LEVEL0;
 DataExportDynamicCalc OFF;
 DataExportNonExistingBlocks OFF;
 DataExportDecimal 3;
 DataExportPrecision n;
 DataExportColFormat ON;
 DataExportColHeader "Métricas";
 DataExportDimHeader ON;
 DataExportRelationalFile OFF;
 DataExportOverwriteFile ON;
 DataExportDryRun OFF;
 };


FIX("Jan":"Dec", "Real",@Relative("Currency",0), "Version Working""FY12",@Relative("Entity",0), @Relative("Customer",0))

/*Same cube folder */
     DATAEXPORT "File" "|" "Sales_YYYYMMDD.txt" "0";

ENDFIX

------------------------------------------------------------------------------------------------------------

SET DATAEXPORTOPTIONS
{
DataExportRelationalFile ON;
DataExportLevel Level0;
DataExportDynamicCalc ON;
DataExportNonExistingBlocks OFF;
DataExportDimHeader OFF;
DataExportOverwriteFile ON;
};


FIX("Unit Price","Unit Quantity","USD", "CLP", "FY13","Working Version"@Relative("Customer",0), @Descendants("Total Año")

/* Other destination folder */
    DATAEXPORT "File" "," "F:\cantidad.txt";

ENDFIX

No hay comentarios:

Publicar un comentario