Skip to Content
0

How to retrieve data from database to Excel spreasheet?

Mar 03, 2017 at 02:38 PM

122

avatar image

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?

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

8 Answers

Vadim Kalinin Mar 03, 2017 at 02:51 PM
0

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?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

It is BPC embedded

0

I am talking about the name of the BPC tables where the data are sent to database

0

In BPC embedded the data is stored in BW cubes....

0
Serge Bambara Mar 06, 2017 at 08:14 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 06, 2017 at 10:18 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Mar 06, 2017 at 11:10 AM
0

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...

Share
10 |10000 characters needed characters left characters exceeded
Serge Bambara Mar 06, 2017 at 11:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Serge Bambara Mar 06, 2017 at 11:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Serge Bambara Mar 06, 2017 at 11:03 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Marc Kuipers
Mar 09, 2017 at 07:59 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded