Goals

  • 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

Audience

  • Application Consultant
  • Developer Consultant

Prerequisites

Essential

  • BOAN10 SAP BusinessObnjects Analysis, Edition for Microsoft Office

Recommended

  • None

Course based on software release

  • SAP BusinessObnjects Analysis, Edition for Microsoft Office 2.2

Content

  • Introduction
    • Introducing Use Cases for SAP BusinessObjects Analysis
  • VBA Basics
    • Getting Started
    • Objects, Methods and Properties
    • Using Variables
    • Explain Debugging
  • Prepare a Workbook for Business Users
    • Show the Prompt Dialog via a Macro
    • Show and Hide Analysis UI Components
    • Save Analysis Workbooks with Macros
  • Change Filters and Variables via Macros
    • Filter your Analysis Data Source
    • Conditional Statements
    • Work with Messages
    • Use ActiveX Controls in your Workbook
    • Programming Loops
    • Programming Arrays
    • Change a Variable Value
  • Use Context Sensitive Information
    • Get Analysis Specific Information for a Cell
    • Call the Member Selector via VBA
    • Use Double Click for Navigation
  • Tips and Tricks
    • Tips and Tricks

Notes

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