|
Duration: 3 Hours
Skill Level: Basic
Short Overview: This course continues from where the Basic Reporting Techniques class ends. It adds the core functionality of that course by teaching the students to use Member Selection, Dynamic Time Series members, Attribute dimensions, and Cascading of reports to build more sophisticated reports and use more of the functionality that the Essbase Spreadsheet Add-in has to offer.
Audience: End-users, analysts, and designers of Essbase reports.
Prerequisite: Basic Essbase reporting knowledge or completion of Basic Reporting Techniques for Essbase class; proficiency with Microsoft Excel.
What You Are Taught:
Use advanced Essbase options to create more sophisticated reports
Understand the report development process
Identify page, row, and column headers in a report
Identify and avoid displaying Label Only members in a report
Create report titles to avoid end user confusion in interpreting the contents of a report
Add formulas to a report
Identify shared members and alternate roll-ups to avoid misinterpreting the data within a report
Retrieve a subset of a report
Create multiple reports on one sheet and retrieve data into each of them
Select members from dimensions with many members and/or having many hierarchical levels using Member Selection
Create reports using Dynamic Time Series and Attribute dimension members
Create multiple reports from a single report using the Cascade command
|
