Training Schedule Training Schedule

(BOAN15) VBA Programming in SAP BusinessObjects Analysis Edition for MS v17
Code: BOAN15 v17
Type: null
Tuition (USD): $750
Length: 1 Day
Have a question?

Contact Us

character(s) remaining

Contact us for upcoming dates.
Skills Gained:
To learn the foundations of Visual Basics for Applications (VBA) programming based on simple examples. To get to know specific Analysis VBA programming, based on practice- oriented tasks and exercises
Who Should Attend?
Application Consultant Developer Consultant
Prerequisites:
  • Essential: BOAN10 SAP BusinessObnjects Analysis, Edition for Microsoft Office
What You Will Learn:
  • 1) Introduction
  • a) Introducing Use Cases for SAP BusinessObjects Analysis
  • 2) VBA Basics
  • a) Getting Started
  • b) Objects, Methods and Properties
  • c) Using Variables
  • d) Explain Debugging
  • 3) Prepare a Workbook for Business Users
  • a) Show the Prompt Dialog via a Macro
  • b) Show and Hide Analysis UI Components
  • c) Save Analysis Workbooks with Macros
  • 4) Change Filters and Variables via Macros
  • a) Filter your Analysis Data Source
  • b) Conditional Statements
  • c) Work with Messages
  • d) Use ActiveX Controls in your Workbook
  • e) Programming Loops
  • f) Programming Arrays
  • g) Change a Variable Value
  • 5) Use Context Sensitive Information
  • a) Get Analysis Specific Information for a Cell
  • b) Call the Member Selector via VBA
  • c) Use Double Click for Navigation
  • 6) Tips and Tricks
  • a) Tips and Tricks
  • Notes
  • • This course is designed for an audience, which has no or little knowledge of VBA.
Course Info:
Course based on software release: SAP BusinessObnjects Analysis, Edition for Microsoft Office 2.2

Analyse OLAP sources in MS Excel and create intuitive presentations with MS PowerPoint usnig SAP BusinessObjects Analysis Addins.

Course notes and announcements:

1) This course is designed for an audience, which has no or little knowledge of VBA.

This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides

All in person classes are taught by an SAP Certified Instructor and will include both a hard copy and e-book student guide for you to keep. This 1 day instructor led course qualifies for 8 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com