cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 10/ EPM - Copy/Paste Members Functionality into Reports

Former Member
0 Kudos

Hello,

I have a requirement for an input schedule in an excel spreadsheet BPC 10/ EPM:

- 1st step: fill the input schedule members (rows) with copy/paste functionality;

- 2nd step: when the user opens the spreadsheet after saving the data in the 1st step, he wants the report to display the inserted values;

To acomplish this, I have defined my input schedule with base level members I want to visualize, selected the option "remove emptys" and the sheet option "member recognition".

What happens is that when I copy/paste the members to the input schedule it refreshes the spreadsheet and the values dissapear because they are "empty".

When I click right-button option EPM->Insert Members-> and choose the members, the procedure is the same, the spreadsheet refreshes but the lines don't dissapear, even tough they are empty.

Can you please help me?

Is this even possible? If not, should I write a SAP note to request assistance?

Thanks in advance!

Best regards

View Entire Topic
Former Member
0 Kudos

Hello everyone,

I have finally a answer to this problem.

I have reported the bug to SAP, they have said that the difference between the two options "Insert Member" or "Copy/Paste" is that:

- In copy/paste option, the refresh report event is triggered automatically after the copy/paste; - this is why the empty rows dissapear;

- In "Insert Member" option, the refresh report event is only triggered after the user refreshes data - so the lines don't dissapear.

Proposed solution by SAP:

1. EPM tab -> Options -> User Options -> "Freeze Data Refresh"

    

     If the user enables this option when he wants to copy/paste the values, the empty rows won't dissapear because the report won't refresh data;

     Disadvantage: it can induce the user into thinking that he has no data, when the option is selected.

Solution proposed by me (more user friendly):

1. If you only have a report in the same sheet (I've tried for several reports and this solution does'nt work - see my other post (http://scn.sap.com/thread/3344216)

     1.1 Create a checkbox entitled "Remove/Show Empty rows";

     1.2 Point the result of this checkbox to a excel cell (for example B29) that you can reference with TRUE (if checkbox selected) or FALSE (checkbox not selected);

     1.3 Build the formula, based on the previous cell, to change the ReportOptions "KeepEmptyRows":

     =IF(B29=TRUE;EPMReportOptions(EPMReportID(E13);"KeepEmptyRows=FALSE");EPMReportOptions(EPMReportID(E13);"KeepEmptyRows=TRUE"))

     Hope this helps!

Thank you for all your help!