<img src="https://certify.alexametrics.com/atrk.gif?account=3HHNq1DlQy20Y8" style="display:none" height="1" width="1" alt="">
Businessman-reading-a-newspaper-000070585809_Large_cropped_again.png

SAP Analytics
Thought Leadership

HOW TO: Suppress Send Dialog Box in SAP BPC

Posted by
Deb Silverman
Deb Silverman
on Fri, Mar 04, 2016 @ 09:03 AM


BPC has always been a flexible tool with many “hooks” through Excel and the database layer enabling all manner of customizations to increase usability to customers’ exact specifications. The risk of How_To_Suppress_Send_Dialog_Box_in_SAP_BPC.pngcustomizing is the potential of that customization being an impediment to an upgrade. One popular access point provided by SAP/OutlookSoft was the “MNU_Commands” hook.

Remember in BPC 7.5 and earlier when we could use a variety of MNU_ commands, include one to suppress the send dialog box?   Many of us cringe at the thought of reverting to VBA, however sometimes we don’t have a choice other than to go without a feature we really want to have.  For one of our clients the number of records being sent was a meaningless number and created confusion, so we set up a simple work-around to clone what they had in 7.5. Road-sign-indicating-Hints-and-Tips-on-blurred-sky-background-000071187189_Small.jpgThey used to be able to suppress the dialog box instructing users to click buttons on the form and for testing developers could use the BPC ribbon and get the usual record count.

We will use an EPM API to hide the EPM submit warning box.  Since this feature is a User Setting, as a general rule, when we make changes to user settings be kind and restore them when they are no longer needed.  We will create a Send Data dialog box and then, in the After_Save function, we will provide feedback that data was sent.

Sub SubmitData()

   Dim I as integer

    i = MsgBox("Send Data?", vbYesNo, "MyCompanyName Data Submission")

    If i = 7 Then Exit Sub 'No

    EPMObj.SetUserOption "HideSubmitWarning", True  'HideSubmitWarning

    EPMObj.SubmitAndRefreshWorkBook

End Sub

Function AFTER_SAVE()

    If EPMObj.GetUserOption("HideSubmitWarning") = True Then

        MsgBox "Data has been submitted", vbOKOnly, " MyCompanyName "

    End If

    EPMObj.SetUserOption "HideSubmitWarning", False

End Function

For more free BPC content, please visit our webcast library! Over 75+ sessions addressing global BPC and EPM questions from various industries.

view webcasts

More Tips and Tricks for you:

Blog Post: SAP BPC Reporting Tips & Tricks

Blog Post: Formatting in SAP BPC

Blog Post: Building a Competent BPC Team

Blog Post: How to Calculate Return on Investment for SAP BPC Projects

Webcast: Best in Class EPM Standards - Customer Roundtable


deb_silverman.png

Author Bio:

Deborah Silverman has been with Column5 Consulting for almost 5 years as a Senior Consultant. She is one of our most popular blog writers with her decades of software experience. She has assisted in hundreds of implementations and specializes in SAP BPC. 

Deborah Silverman, Senior Consultant, US Team

Topics: Thought Leadership, BPC (Business Planning & Consolidation), best

Subscribe

Recent Posts

Posts by Topic

see all

3  S T E P S

To Enhance Your EPM Performance:

 1.Get Your Ultimate Guide to Improving SAP EPM Performance

ebook 2

 Learn what could be contributing to your poor performance and how to diagnose common problems. Get tips that will empower you and your team to improve the  performance  of your system in order to get the most out of your SAP EPM Investment.

Get the e-Book

 

2.  Test Your BPC Performance 

Benchmark 2

Get a BPC performance report card and custom report to identify performance issues you may not even know you have.

Test my BPC

 

  3. Get Your EPM Assessment  

Assessment

Our assessment delivers a complete, best practice roadmap for you to follow.  We’ll work together to assess what you need to pivot your financial forecasting, planning, reporting and analysis to handle the compressed requirements from the volatile COVID-19 environment. 

New Assessment