ODI - Date to Hyperion Planning

Date to Hyperion Planning using ODI

Date member in Hyperion Planning

Sample data file

Creating Model for Source: Text file

Reverse Engineer tab for Source

Creating Data Store

Select Data File in Data Store 

Select Delimited and other format settings

Reverse engineer to get Column name into ODI

Create Model for Target

Creating Interface

Source and Target in Interface

Check out Knowledge Models 

Job ran successfully, and you can see the same in Operator Tab

Verify the results in Planning applicaiton

Verify the results in Samrtview

Thanks,

Mady