Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't upload data via Outline Load Utility command line

JanGLiNov 11 2016 — edited Dec 1 2016

Hi,

Version: 11.1.2.4.004

I am trying to load data into hyperion planning using command line of Outline load utility.

My data form:

pastedImage_5.png

This is my file 1:

Value,Driver Member,Point-of-View,Data Load Cube Name

1111,Employee Count,"Jan, No Line Item,Actual,First Draft,Local,No Entity,No Asset Class,Common Cost Centre,No Future 1,No Product,Common requsition cost center,Employee Count,Common Employees,FY16",Plan2

I have also tried to load the below file.

This is my file 2:

Value,Driver Member,Point-of-View,Data Load Cube Name

1111,Jan,"No Line Item,Actual,First Draft,Local,No Entity,No Asset Class,Common Cost Centre,No Future 1,No Product,Common requsition cost center,Employee Count,Common Employees,Employee Count,FY16",Plan2

My command:

./OutlineLoad.sh /A:HypUAT1 /U:admin /M /I:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.csv /TR /X:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.exc /L:/u01/hyperion/fdmee_custom/WF/WF_AUG-16.log

My log file:

[Fri Nov 11 16:46:25 PKT 2016]Planning Outline data store load process finished. 1 data record was read, 2 data records were processed, 2 were accepted for loading (verify actual load with Essbase log files), 0 were rejected.

My exception file:

\ufeff[Fri Nov 11 16:46:24 PKT 2016]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.

[Fri Nov 11 16:46:24 PKT 2016]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.

I have also checked the essbase log file. I can't see anything related to data loading or file creation for data loading.

I know that all the members are correct, because i have copy/paste these members in GUI version of OLU and i was able to load data from there.

Kindly help.

Regads

This post has been answered by JanGLi on Dec 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details