Retrieve Data from Other Model - EPMRetrieveData

[Former Member]

Hello,

How can we retrieve data from another model?

If I am in the Opex Model and want to pull in Revenue numbers, I am trying to do an EPMRetrieveData, but unsure on the syntax to state that I want the data from a different.

Can anyone help me with that?

Thank you!

[former_member186338 · Accepted solution]

Hi Natalie,

The first parameter of this function is a connection name - that will identify the model. But another option is to create a separate report on the same sheet with the connection to the Revenue model...

B.R. Vadim

[Former Member · Accepted solution]

Hi

So in EPMRetrieveData, the formula would look as follows:

=EPMRetrieveData("REV_PLANNING-ENVIRONMENTNAME","TOT_REVENUE")

I get an error that says "Error, no current connection"

I am currently logged into Opex Planning and not Rev_Planning.

I shouldn't have to be logged into Revenue to be able to pull the details.

Any ideas.

You are the best, Vadim!

[former_member186338 · Accepted solution]

Hi Natalie,

To my mind, you have to be logged to the Rev_Planning in addition to the Opex Planning. Then, "REV_PLANNING-ENVIRONMENTNAME" have to be the exact name of the connection to Rev_Planning.

I will do some tests tomorrow...

B.R. Vadim

[former_member186338 · Accepted solution]

Hi Natalie,

I have done a simple test:

The sheet contains a report based on the model INFILE with a connection "INFILE - SIM". I want to retrieve data from another model ADVSALES with a connection "ADVSALES - SIM".

In some cell I put a formula like:

=EPMRetrieveData("ADVSALES - SIM","BE1000","ACTUAL","2012.JAN","1110","PAGESEDT","PERIODIC")

where "BE1000","ACTUAL","2012.JAN","1110","PAGESEDT","PERIODIC" - is a full tuple description.

After the sheet refresh I got a correct value in this cell.

B.R. Vadim

[Former Member · Accepted solution]

Hi Vadim,

     I have active connection devbwdb4_Test in Development envirronment but when Imove to QA it changes to qasbwbq4_Test.

     So, if i use connection name of dev and when moved to QA it will give me an error. Please provide some

information regarding this.

[former_member186338 · Accepted solution]

Hi,

But what is the issue? What do you want to achieve? The function EPMRetrieveData requires the proper connection name to get data.

Vadim