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!

Exporting Smart List from Planning application

RohitGSep 17 2012 — edited Sep 17 2012
Hi all,

I am working on EPM version 11.1.2 and there is a requirement to create a new ASO reporting cube from the existing HSP (Public Planning) cube.
For doing so I need to load all the smart lists in Planning as dimension in ASO cube. I tried using Outline load utility to take an export of the smartlist metadata so that I can use the output file to load to ASO cube.
However I am not able to achieve this. I am new to Planning and this is my first time with Planning load utility.
this is the command I am using:

/u01/app/orahyp1/Middleware/user_projects/epmsystem1app25/Planning/planning1> sh OutlineLoad.sh /A:DEVTRN /U:admin /E:ASOSmartList.csv /L:ASO.log /X:ASOExc.exc /DS:HSP_SMARTLISTS


Here is what log file says:

[Mon Sep 17 12:21:11 EDT 2012]Unable to obtain dimension information and/or perform a data load: java.lang.NoClassDefFoundError: oracle/dms/context/ExecutionContext
[Mon Sep 17 12:21:11 EDT 2012]Examine the Essbase log files for status if Essbase data was loaded.
[Mon Sep 17 12:21:11 EDT 2012]Planning Outline data store load process finished with exceptions: not all input records were read due to errors (or an empty input file). 0 data records were read, 0 data records were processed, 0 were successfully loaded, 0 were rejected.


I would appreciate if anyone can suggest where am i going wrong.

Thanks in advance
Ranjan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2012
Added on Sep 17 2012
7 comments
1,406 views