Hi FDM experts,
I have an issue that I wanted to reach out to you on regarding fixed-width import formats and how to cater for my current scenario for export to Hyperion Planning.
I am working with a flat file (.txt) I need to import to FDM with the current format;
| A | B | C | D | E | F | G | ... | Z |
| Year | Channel | Product | Jan-MTD-Account 1 | Jan-MTD-Account 2 | Jan-YTD-Account1 | Jan-YTD-Account2 | .... | Dec-YTD-Account2 |
|---|
| 2013 | Channel_1 | Product_1 | 1000 | 2000 | 1000 | 2000 | | 10000 |
These are all fixed in width so the field lengths will need to be defined in the import format. The requirement for loading to the system is only a speciifc Month YTD value for both Account1 and Account 2.
If my chosen Month is 2013 Jan, I will only require columns F and G to be loaded. These are the issues I have identified;
- Can a fixed width import format cater for loading to multiple accounts in the same file? Or would I need a separate import format per account?
- Can a fixed width import format cater for loading to a variable Actual Month period? Or do I need 12 import formats/locations per month?
Your help is much appreciated!
Many thanks
Aaron