Wat is VBA Programming in SAP Analysis for Microsoft Office
In this course you will explore the integration of VBA programming with Analysis for Office functionality to provide interaction directly from worksheets. NOTE: This course is applicable for customers on the SAP BusinessObjects BI Platform version 4.2 or 4.3, as well as for customers using only an SAP BW Platform. Course based on software release: SAP BusinessObjects BI 4.3, SAP Analysis for Microsoft Office 2.8.
This course will prepare you:
- 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
-
Contents:
Introduction to VBA Programming in SAP Analysis for Microsoft Office
VBA Basics
Outlining Visual Basic for Applications
Using Objects, Methods, and Properties
Using Variables
Explainng Debugging Mode
Prepare a Workbook for Business Users
Showing the Prompt Dialog Using a Macro
Showing and Hiding Analysis UI Comonents
Saving Analysis Workbooks with Macros
Change Filters and Variables via Macros
Filtering your Analysis Data Source
Understanding Conditional Statements
Working with Messages
Using ActiveX Controls in your Workbook
Explaining Loop Programming
Explaining Array Programming
Changing a Variable Value
Use Context Senstive Information
Obtaining Analysis Specific Information for a Cell
Calling the Member Selector Using VBA
Using Double Click for Navigation
Tips and Tricks
