on 04-23-2013 6:26 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.