on 10-01-2013 7:20 PM
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;
2. Reading data from infocubes, through a BW direct connection;
http://scn.sap.com/thread/3294990
3. RUNLOGIC_PH Keyword
Please share your expertise
Best regards,
Raquel
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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,
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
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!
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.