Can we pull transaction data from BPC to GR using GRDC or any other option ?

[parthiv1994]

Hi Experts,

In one scenario, there are some subsidiaries that are doing consolidation in BPC, and now we need to pull that consolidated data into group reporting for final consolidation.

So can we directly pull transaction data from BPC to GR using GRDC or any other option?

[Arleigh]

Hi Parthiv,

So with that information GRDC is probably your best option. There is a spreadsheet upload built into the Data Monitor but it's looking for a perfectly formatted CSV file and the validation capability is quite limited. You could also use an API but then you need to write code.

The advantage of GRDC is it has very good data transformation capabilities so you export the file from BPC, GRDC uploads the file, transforms the file and imports it in all via a scheduled job (if you want to use that option) and if there are issues it has a very detailed log file that can be selected to run with the import.

In my mind GRDC is probably your best option.