I am looking into loading journals using an output file in SAP BPC intead of entering every journal using the template.
I have found that 3 DTS packages exist for this issue:
Export the Journal Tables
Clear the Journal Tables.
Restore the Journal Tables.
I have added these packages (using the three .dtsx files that are in the server, in the "Examples" folder) and, after that, run the packages in the proper order. I have some doubts that I would appreciate if you could solve them:
1.- When I run "Export the Journal Tables" package, I can NOT make a selection of journals (for example, using Time dimension).There is no possibility. Is it possible modify this DTS package to export only some selected journals? In case it is, how?
2.- In order to restore journals table, firstly you need to clear all the table using "Clear the Journal Tables" package (I tried to do it without clearing all the journals, and I got an error message that said that I have to clear the journal table before importing ). Would it be possible to restore/import only some journals WITHOUT clearing ALL the previous journals??
3.- I have exported the Journal Table to an output file, clear all the journals in the Journal Table (using the proper package) and run the "Restore the Journal Tables" package using the output file I have gotten before. I have gotten this error: "Exception from HRESULT: 0x800A005B". Do you know what's the problem?
4.- Dou you know another way of loading journals using an output file in SAP BPC intead of entering every journal using the template?
Thank you very much.