What is the error in .err file... Are you sure outline is in sync between both applications.
Why don't you try free export by right click on database (export option) and load it to target application.
.err file has nothing.Yes outline is in sync.to automate the process i used maxl query
thanks for your update.
and here i got an answer.FYI. i have created a new rul for exported file and then i imported.it worked now.
Thanks a ton!
Y don't you use CDF function by oracle its free
look for CDF_Export.zip
register and run the calc it would take less than 5 mins to extract but again depands on ur cube size
You are not clearing the database and you are importing the same level0 data to the cube. Why are you expecting it to modify the data which is already present. The message is telling you that there was nothing to modify. (all the data values are the same).
I am clearing database using
alter database APP.DB reset;
and then importing again that exported data back to cube using
import database 'APPNAME'.'DBNAME' data from local text data_file 'E:\HYPERION\DATA\export.txt' using server rules_file 'loadplan' on error write to 'E:\HYPERION\logs\export.err';
1 person found this helpful
I don't understand why you are even using a calc script to export all level 0 data! Just use the Export Data maxl command as Shiva suggested. The benefit of this approach is that you wont need a rules file to load the data back in.
We also don't really need to be getting into CDF world here with this requirement! This requirement to export, defrag, update outline and reload is a fairly common and standard process that can be achieved very easily using MAXL for the Export, shell to copy the outline and then MAXL to load the exported data again.
You should only really be using a calc script to export data if you need to restrict your data export to a 'slice' of the data. You are creating more work for yourself