BOAN10 - Analysis, edition for MS Office

Recommended

• Basic BEx Analyzer experience

• In more than 15 exercises, you will learn the complete functional scope of Analysis 1.1, edition for Microsoft Office.
  • Basic Fuctions
• Navigation within the Design Panel
• Working with hierarchies, conditional formatting and filter on measures
• Use of formulas
• Integrating dynamic text elements, charts and filter elements
• Creation of PowerPoint slides from Excel
  • Special Functions
• Working with styles
• 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