cancel
Showing results for 
Search instead for 
Did you mean: 

How to reset a specific intersection of a BPF?

Former Member
0 Kudos

How do you reset a specific intersection of a BPF? It seems like there is a function to reset the BPF for all dimension members but I do not know of a way to only reset a specific intersection. As an example, if Budget V1 is locked down and Budget V2 is being worked on but I need to re-open the BPF for a given entity or cost center, I don’t want other Budget V1 to be unlocked and other entities or cost centers under Budget V2. Any information and help is greatly appreciated. Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The prior response is an accurate picture of the process that may be undertaken. At this current state of the product, we do not have a simple way to reset a specific user or step in the process and this has been identified as an area for improvement. I would encourage you to submit an enhancement request with SAP Support, so that we continue to grab the eyes of development for this functionality.

Former Member
0 Kudos

Hi Clinton,

There is a workaround to set the individual BPF step statuses without resetting the entire BPF instance. I use this technique so I don't have to open the BPF, set each individual step to complete, and then accept or reject each step (if you have enabled review). This is particularly useful when I am creating a demo and I want to set the BPF steps to show in the BPF Status report (DemoBPFReport.aspx) to illustrate the different completed, ready, rejected, and review-required steps for each Entity that is using the BPF. Although this technique may appear to be cumbersome, it is much quicker than opening the BPF for each entity and then setting each step in the BPF to the applicable "state."

Although you are using this technique for a different purpose, the concept still applies to your needs. In your case, I believe you want to set individual steps within the BPF to the Completion Required (Not Started) state, so in the following instructions, you would enter 0 for the applicable BPF steps.

To use this technique, you must have access to the SQL tables and you must know the following:

  • The BPFID (you can find this in the URL when you launch the BPF from Excel or Web)

  • The StepID of each step used in the BPF (these are listed in the dbo.BPFStatus table)

  • The latest BPF InstanceID (each time the BPF is accessed, a new instance is created)

To update the steps in a BPF

1. Open the BPF with the CV values set to the applicable entity for which you want to set the steps' statuses.

This creates a new instance of the BPF record in the dbo.BPFStatus table.

2. In SQL Server Management Studio, perform the following:

a. In the Object Explorer, expand Databases, expand the applicable database, and then expand Tables.

b. Open the dbo.BPFStatus table.

c. Find the latest instance for your BPF and, for each step, in the Completed column, set the applicable Step property:

The values are

0 = Completion Required (Not started)

1 = Reviewed (Step Completed)

2 = Completion Required (Step Rejected and Awaiting Update)

3 = Review Required (Step Awaiting Review)

For example, assume for the latest instance I0000000000044 of my BPF (B00000000008), I have 3 steps: S00000000123 (step 1), S00000000124 (step 2), and S00000000125 (step 3).

If I set the Completed property to the following:

BPFID | InstanceID | StepID | Notification | Ready | Completed

B00000000008 | I0000000000044 | S00000000123 | False | False | 1

B00000000008 | I0000000000044 | S00000000124 | False | False | 1

B00000000008 | I0000000000044 | S00000000125 | False | False | 2

when I open my BPF, the steps are set to:

Step 1: Reviewed

Step 2: Reviewed

Step 3: Completion Required (Rejected)

3. Close the dbo.BPFStatus table.

4. In the BPC Web browser displaying the BPF, click Refresh.

The Business Process Flow opens with each step reflecting the Completed column property you set in the dbo.BPFStatus table. At this point, the DemoBPFReport.aspx file gets updated to reflect the BPF steps' statuses:

Step 1: Step Completed

Step 2: Step Completed

Step 3: Step Rejected and Awaiting Update

To view the DemoBPFReport, from the Performance Management Dashboard, in the Action Pane, click the link to the DemoBPFReport.aspx file. Note that if the link in the ActionPane.xml file does not specify the correct BPF and its dimensions, then the report will not update with the changes to the BPF you made in the table.

5. Click Getting Started, and repeat these steps for the other entities you want to include in the BPF status report.

Former Member
0 Kudos

Eric,

I understand all of your instructions except,

"To view the DemoBPFReport, from the Performance Management Dashboard, in the Action Pane, click the link to the DemoBPFReport.aspx file. Note that if the link in the ActionPane.xml file does not specify the correct BPF and its dimensions, then the report will not update with the changes to the BPF you made in the table."

I do not see the link to "DemoBPFReport.aspx"

Could you explain this further?

Thanks,

Tim