Skip to Content
avatar image
Former Member

Upload excel file in BPC cube

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05, 2017 at 07:51 AM

    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)

    Add comment
    10|10000 characters needed characters exceeded