Skip to Content
0

Upload excel file in BPC cube

Jan 05, 2017 at 05:58 AM

149

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jan 05, 2017 at 06:44 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 05, 2017 at 07:51 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded