BPC to HFM Budget Data Trasfer

[Former Member]

Hi Folks...I need to get some suggestion on extracting data from BPC 7.5 Version into HFM who needs the data in a perticular format in flat file which required clubbing together my 4 application transaction data into one single file.I have the following options :-

1) Create a Z program which will extract the data from the 4 BPC Cubes using function module RSDRI_INFOPROV_READ_RFC and club together the file in the program and generate a single flat file.

2) Use BPC export data Manager and dump the Transaction Data from 4 application and the program will pull the files and generate the required file format for HFM.This program will be easier

With the first approach we are afraid that the technical name of BPC cubes might change during transport or optimization.Is this a valid concern or do u guys think option 2 is a better and safer version

[Former Member]

Hi Aeroshil,

I would suggest the second method, wherein you first export the data, then combine them, and do the structuring or manipulations in that. It might be easier.

Since you will be using the standard method for exporting the data from the applications, you dont have to worry about the optimization at all.

Hope this helps.