Upload excel file in BPC cube

[former_member261632]

Dear All,

We are using SAP BPC NW ver 10.

There is a requirement of uploading an excel file directly in the BPC cube (single file, single cube, there should be no BW interference). In one of the answers I found EVDRE as a solution to this.

Q1. Is it possible in BPC NW 10?

Q2. If yes, please provide a link or explanation how this is done.

[former_member186338]

You have 2 options:

1. Text file data import (like in JP post)

2. Input form to load data based on EPM report (like EVDRE in 7.5)

[Former Member]

Hi Santosh,

Perhaps if you are new to BPC then instead of posting basic questions in forum...why not search first! Thousands of links and documents available! EVDRE is used in SAP BPC 7.5 NW! not 10 NW.

An Excel file converted to.csv(comma separated value) format is used to upload data whether master data or transaction data in BPC!. Check these links...

https://blogs.sap.com/2015/04/14/master-data-loading-from-flat-file/

http://jaybpc.blogspot.in/2014/02/loading-transaction-data-from-flat-file.html

Always use BPC 420 and 430 documents for BPC 10 NW help

https://cdn2.training.sap.com/cdn/course-pdf/BPC420_EN_Col97_FV_CO_A4.pdf/G/EN/BPC420/097

https://cdn2.training.sap.com/cdn/course-pdf/BPC430_EN_Col16_FV_CO_A4.pdf/G/EN/BPC430/016

Regards,

JP