3 Replies Latest reply on Oct 19, 2010 6:01 PM by TonyScalese

    Import data to Hyperion Planning via FDM

    806463
      Hi,

      I would like to do an import a multiload file in FDM I mean import a unique excel or text file with multi period (18 month).
      My customer requirement is to enter data into an excel file in row so I need to write a VBA macro to transform it into a correct format for FDM.
      My question is does we can import 18 period with a text file via FDM wich would have this format :


      Default Supplier
      Budget10
      11/01/2010
      18
      R,R
      Account|Center|Description|YTD||Customer|New Product Familly|Application|Currency|V|V|V|V|V|V|V|V|V|V|V|V|V|V|V|V|V|V|V
      Sales revenue|Toto INC|partID number 007|YTD||Customer01|PF1|Application1|USD|1201|1202|1203|1204|1205|1206|1207|1208|1209|1210|1211|1212|1213|1214|1215|1216|1217|1218
      Sales revenue|Toto INC|Toto|YTD||Customer01|PF2|Application2|USD|1300|1202|1104|1006|908|810|712|614|516|418|320|222|124|26|-72|-170|-268|-366
      Prototype revenue|Toto INC||YTD||Customer01|PF3|Application3|USD|1399|1202|1203|1006|1205|1206|1207|1208|1209|1210|1211|1212|1213|1214|1215|1216|1217|1218
      Sales Volume|Toto INC||YTD||Customer02|PF1|Application4|USD|1498|1202|1302|1006|974|876|778|680|582|484|386|288|190|92|-6|-104|-202|-300
      Sales Volume|Toto INC||YTD||Customer02|PF2|Application5|USD|1597|1202|1401|1600|1799|1998|2197|2396|2595|2794|2993|3192|3391|3590|3789|3988|4187|4386
      Sales Volume|Toto INC||YTD||Customer02|PF3|Application6|USD|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18