This discussion is archived
1 Reply Latest reply: Mar 29, 2013 2:57 PM by Ayush Ganeriwal RSS

How to Load Dates Data type from txtfile to Hyperion Planning

975788 Newbie
Currently Being Moderated
I have loaded numeric and string data for especify combination, for example

soruce Txtfile:
Year Measures Market Data1 Data2
"Jan","Sales","New York","120","2013/01/01"

Hyperion Planning:

(combinations in my target)
Jan,Sales,NewYork,E_1011--->120
Jan,Sales,NewYork,E_1008--->"not loaded"

E_1011 is defined as Numeric data type in Hyperion Planning
E_1008 is defined as Date data type in Hyperion Planning

In my Interface source file, field Data1,Data2 is defined as "String", why ODI is loading only Data1 field?, how can I do for load Data2 field.

Thanks for your help.

Legend

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