on 02-16-2009 10:18 AM
I am looking into loading journals using an output file in SAP BPC intead of entering every journal using the template.
Hello everybody,
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.
There may be options to your process, but as I have mentioned in other strings, the Journals in the BPC for Microsoft version are sequenced. That means that there is a system generated sequence ID for each journal. Any individual selection of journals would possibly cause an issue for the sequence. I have not seen any past work in SSIS to detach the records for export or import. It may be possible, but I would assume it will take some core SQL coding.
Regarding your error, you may need to verify that you have the security set correctly to use Journals and use the Data Manager capabilities. Typically, when security tasks are not correct, you will get an error similar to your HRRESULTX.... error.
An option for loading the details is to build a worksheet in EVDRE, aggregate the data and send it to the cube at a level that is easy to save the file and submit consolidated results. Just make sure you send all "like" records at an aggregated to a base member, and send to a datasrc to identify the extra details. Then store the excel file with the input values.
Hope this helps.
Edited by: Petar Daniel on Feb 16, 2009 10:06 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.