cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

  • anyone ever used this?

Please share your expertise

Best regards,

Raquel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Raquel,

You can pull data from all five models in your report. You have to establish connection to the required model and pull the data. All the reports can be in one workbook/worksheet.

Regards,

Kalyan.

former_member186338
Active Contributor
0 Kudos

Hi Raquel,

Kalyan is right, you can have number of reports on one sheet with axis sharing. We use this approach to show data from 3 models in 5 reports with column axis shared. Page and row axis is unique for each report (some common values are linked by Excel formulas).

The performance of the report is OK.

B.R. Vadim

Former Member
0 Kudos

Thank you for all the responses.

@ Vadim Kalinin and @ Kalyan Dey 

1. How would I configure my BPF activity to this Report?

2. The report contexts are different for each report in the same page?

I have 3 dimensions that are common between all 5 models: CATEGORY, VERSION and TIME. These dimensions are updated by the context, when the activity opens the report.

@ Nilajan Chatterjee

It is BPC reporting. I think its possible to establish a connection directly between BW and BPC Infocubes, but I don't understand quite well the advantages of this solution.

Best regards,

former_member186338
Active Contributor
0 Kudos

Hi Raquel,

We use multiple reports on one sheet only for reporting purposes not as an input schedule for BPF. For input schedule we usually use one model per sheet, it's our internal requirement. Somebody else may share experience...

When we speak about report context it depends what type of report you want to have: dynamic, static or semi-static. In our case we use static reports with excel formulas to ensure that the same common members will be used for all reports.

B.R. Vadim

former_member186338
Active Contributor
0 Kudos

P.S.

By the way, in case we need to calculate some KPI's that require data from more then one model we use script logic to copy the required data to one model and use member formula to calculate KPI. Example:

We have Finance P&L cube with the account member Printing_Expenses (for magazines print)

We also have Copy sales cube where we have member Total_Qty (Total number of magazine copies printed).

We want to have KPI - Print_Exp_Per_Copy (printing expenses per copy of magazine)

We created Total_Qty member in Finance P&L cube and use this script in default.lgf for Copy sales cube:

*DESTINATION_APP = Finance //Write to Finance P&L cube

*RENAME_DIM COPY = INACCT //Rename account dimension: COPY in Copy Sales to INACCT in Finance

*WHEN ADV

*IS "Total_Qty" //If Total_Qty changed by user then copy it to Finance cube

   *REC(EXPRESSION=%VALUE%)

*ENDWHEN

Then in Finance P&L we have a member formula for Print_Exp_Per_Copy:

IIF([Total_Qty]=0,NULL,[Printing_Expenses]/[Total_Qty])

B.R. Vadim

Message was edited by: Vadim Kalinin - member formula added!

Former Member
0 Kudos

Hi Vadim,

The goal is to have a report with several financial indicators, as well as production unitary costs and sales ammount.

Could you please explain why you say that BPF activities is only for input schedules? How do the users open the reports? By the root folder?

I think maybe we are mindset to use BPF activities with predefined work area so the users just refresh the report for the category, version and year of budget.

Maybe your users are more advanced and acess to context, and change in order to get the information, is that it?

For instances, we have several reports within the same workbook with multiple sheets, where we some sheets are input schedules and some are reports as well.

Thank you so much for your help.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Raquel,

My choice would be from options 1 and 2.

If you choose to use EPM addin, then you can go with option 1. If you choose BO reporting, then you can choose option 2.

Hope this helps.