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