Audience Profile

This course is intended for business intelligence analysts, project team members, and “power-users.”

At Course Completion

• Through fifteen exercises, participants will experience and learn of the basic functions, navigation, and layout design options of Business Objects Analysis, edition for Microsoft Office.
• It will prepare particpants to analyse Bex Querys, define formatted workbooks, define navigational elements using VBA.

Prerequisites

Essential:

• Basic understanding of SAP NetWeaver Business Warehouse Querys

Course Outline

• Overview of Analysis, Office edition
• Filtering & Sorting
• The Design Panel
• Navigation Options
• Adding a Chart
• Filtering By Measure
• Working with Hierachies
• Insert Components
• Using Formulas to add additional information
• Conditional Formatting & Prompting
• Change Variables in Prompts and Add Calculations
• Creation of layout elements (e.g.; dropdown boxes) in combination with VBA to control variables and filter values
• Combination of multiple functions into one action
• Advanced scenarios for formula usage