Example of exporting a file
The export file and import features of M3 Demand Planner supports different types of integration. These features can also be used for offline reporting.
This example shows the format that you can use to horizontally export a CSV file:
*Contents; Favorite View = F1 Measure = [LYSA]
*TXT; Country; Warehouse; Product Line; Chanel; Main Product; Key State; Year; Jan. 2010; Feb. 2010;
Mar. 2010; Apr. 2010; May 2010; June 2010; July 2010; Aug. 2010; Sep. 2010; Oct. 2010; Nov. 2010; Dec.2010
;US;US1;Ariel;Channel B;A-11;Normal;2010;;;;673.349;642.756;680.096;685.062;592.087;680.878;844.492;392.011;471.816;193.894;673.349;642.756
;US;US2;Ariel;Channel B;A-11;Normal;2010;;;;673.349;642.756;680.096;685.062;592.087;680.878;844.492;650.602;710.241;788.855;718.373;756.325
;UK;UK;Ariel;Retail A;A-11;Normal;2010;;;;4.372.376;5.175.422;5.534.997;5.575.397;4.793.081;4.391.795;3.363.345;2.596.067;5.994.148;9.317.121;4.372.376;5.175.422
You can edit a CSV file format using Microsoft Excel, Notepad, or any text editor application.
In this example, the CSV files are created after you click the button in the dialog box:
- Calculated forecast in dollars
- Total forecast in dollars
- Last year's sales
You can set the parameters for horizontal export in the dialog box.