Skip to Content
avatar image
Former Member

How to retrieve data from database to Excel spreasheet?

I am using BPC for NW( 10.1).

I've created an Input Schedule(I-1) using BPC for excel and sent data to the database.

I need this (I1) data to use it in a new Input Schedule(I-2), for further manipulation.

How will I do to retrieve data from the database to excel spreadsheets?

Where is the name of the Table where the data sent to database is stored?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Mar 03, 2017 at 02:51 PM

    Sorry, but you are posting something strange...

    "How will I do to retrieve data from the database to excel spreadsheets?

    Where is the name of the Table where the data sent to database is stored?"????

    In order to retrieve the posted data you use EPM report... What is the issue?

    What BPC are you using - standard or embedded?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 08:14 AM

    Ok Thanks and how to retrieve this data stored in BW cubes to Excel spreadsheet?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 10:18 AM

    "retrieve this data stored in BW cubes to Excel spreadsheet" using report like input form! What is the issue?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 11:10 AM

    Sorry, but you are asking absolutely basic questions about EPM... You need to read at least EPM help!

    You can create EPM report the same way you created Input Form and get the data to Excel...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 11:03 AM

    What EPM function to use for retrieving the data stored in BW cubes to excel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 11:03 AM

    What EPM function to use for retrieving the data stored in BW cubes to excel

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 11:03 AM

    What EPM function to use for retrieving the data stored in BW cubes to excel

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2017 at 07:59 PM

    Hello Serge

    The whole point of EPM add-in is that all the tables etc. are transparent to the end-user

    So, if you connect to the BPC web-services (http://server:port/sap/bpc/) and select a ENV.model, the report you create will automatically retrieve the data from the relevant tables

    You will never be exposed to the BW tables names (e.g. /CPMB/A9INS7X ) in the EPM add-in

    You can use function =EPMRetrieveData() if you want, but it will still need a valid connection, and not table names

    Marc

    Add comment
    10|10000 characters needed characters exceeded