How to upload multiple flat file into BPC 10

[Former Member]

Hi Experts,

I need to upload multiple flat files in BPC server through single transformation and one data manager package to automate the things or to reduce the work time.

Any idea like for single file we are doing

1-convert a flat file in to CSV

2- Upload CSV in to BPC server

3-create transformation file

4-create conversion file

5-run and validate conversion file

6-validate and exe transformation file

7-run data manager package

Now on run data manager package how to select multiple .CSV files

or else please let me know the way to upload multiple file in single time.

Thanks,

Ravi

[smothukuri]

Hi Ravi,

If you want multiple selections in Import file select and Shift+Down Arrow, only particular selection use Ctrl+Click on particular file.

Thanks,

Subbu.

[Former Member]

Hi Nani,

Thanks but i am asking to load data in to (/CPMB) through BPC 10.

Thanks,

Ravi

[former_member186338]

It's possible to select multiple files, but the package will fail with multiple file selection

[former_member186338]

Hi Ravi,

Not clear:

Do you load all files to the same model?

Why do you need different transformation/conversion files?

...

Please provide samples to understand your requirements.

Vadim

[Former Member]

Hi Vadim,

Ok..

For example

1- There are 2 models Finance model and Sales model.

Now i am getting 2 flat files can we handle this with one  transformation file and load data in to BPC 10(/CPMB)

2- Now other example ..

Having Sales Model and getting 4 flat files from client fro the same model . now u are asking that why for the same model 4 different files ok here i want to clear that data is different but format is same for Sales model and i do not want to merge this 4 flat file into one single flat file i want to avoid this any option that we can handle ?

Thanks,

Ravi

[former_member186338]

"1- There are 2 models Finance model and Sales model.

Now i am getting 2 flat files can we handle this with one  transformation file and load data in to..."

Not possible - different transformation files required!

"Having Sales Model and getting 4 flat files from client fro the same model" if number of files and filenames are fixed - you can use package link with 4 packages to process. But file merge can be a better solution (using some simple script!)

Vadim

[Former Member]

Hi Vadim,

Thanks, Package link with 4 packages to process, any online help is there like document or link ?

Regards,

Ravi

[former_member186338]

Ups, just test yourself: Manage Package Links - SAP BusinessObjects Planning and Consolidation - SAP Library