Skip to Content
0
Former Member
Oct 01, 2013 at 06:20 PM

EPM Data Retrieve from other Models in Same Environment - Most Performant Way?

168 Views

Hello experts,

I have a client requisite that envolves reading data from all models in the environment.

They want to have an integrated model, that has several financial indicators, production volumes, production costs, purchase costs etc.

We need to have a performant way to read all data, from several models (5) and we need the data to be always updated at the time (so, script logic to copy values are not an option).

We are considering 3 options, I would like to ask you, what is your expert opinion. How would you implement this?

Options:

1. EPMDataRetrieve function module;

  • is this solution performant enough?
  • what is the best way to manage the members in the formula?

2. Reading data from infocubes, through a BW direct connection;

http://scn.sap.com/thread/3294990

  • is this more performant than option 1?
  • has anybody implemented this? is it easy?

3. RUNLOGIC_PH Keyword

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/903c14d2-6741-3010-34b2-9ae9822c26ca?QuickLink=index&overridelayout=true&57909044138975

  • anyone ever used this?

Please share your expertise 😊

Best regards,

Raquel