Followers

Thursday, June 22, 2017

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