Smart View Toolkit

    

Summary:
This course covers specialized Excel techniques and introduces you to Microsoft's Visual Basic for Applications (VBA) language using the Smart View VBA functions. By the end of this course you will be able to automate business processes using VBA macros and your Smart View Essbase database.

Duration:
2 Days/Lecture & Lab

Audience:
This course is intended for end-users, report developers, and application developers who need to simplify and streamline business reporting and analysis.

Topics:

• Review of basic reporting
• Smart View VBA functions features and overview
• Macro terminology
• Toolkit terminology
• Recording macros
• Writing and editing macros
• Adding controls to the worksheet
• Declaring Smart View VBA functions
• Using Smart View VBA functions
• Building macros for Smart View Essbase reporting
• Formatting and layout considerations
• Building dynamic Smart View Essbase reports
• Smart View VBA functions to control the environment
• Automating Smart View Essbase reporting
• Designing report templates
• Report Generation Workshop

Prerequisites:
Hyperion Smart View for Essbase or equivalent experience.

Last Update: June 18, 2013