4 Replies Latest reply: Jan 23, 2014 12:40 AM by Francisco Amores RSS

FDM Fixed-Width Import Format & Multiple Accounts/Periods Issue

atsoi Newbie
Currently Being Moderated

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;

 

ABCDEFG...Z
YearChannelProductJan-MTD-Account 1Jan-MTD-Account 2Jan-YTD-Account1Jan-YTD-Account2....Dec-YTD-Account2
2013Channel_1Product_1100020001000200010000

 

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;

 

  1. 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?
  2. 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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points