This course teaches you how to create focused reports using OLAP analysis cubes, report templates, and the classic analytic view of an ABC model. This self-study course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software practice

Learn how to

• build reports for both model validation and analysis
• design effective reports that reflect the report consumer's preferred style
• use online analytical processing (OLAP) for custom reports
• use SAS Enterprise Guide to pull SAS Activity-Based Management model data to construct custom reports
• prepare your reports for delivery.

Who should attend Model builders who are responsible for creating and maintaining standard and custom SAS Activity-Based Management reports Formats available Duration
: 14 hours/180 day license

Before attending this course, you should have completed the course or have equivalent experience. Experience with SAS Enterprise Guide, which can be gained by taking the course, is recommended.

This course addresses SAS Cost and Profitability Management Standard software.

Standard SAS Activity-Based Management Reports and Report Dependencies

• identifying report templates and their dependencies

Model Validation and Analysis Reports

• identifying and describing reports used to analyze or validate a model
• identifying the characteristics of effective reports

Advanced OLAP Reporting with SAS Activity-Based Management

• identifying and developing cube configurations
• setting dimension-level depth in cube configurations
• creating unique level names
• filtering dimension members in cube configuration
• applying in-out cost flow to selected dimensions or stages

Customizing Cubes for Reporting

• explaining the advantages of the SAS OLAP Server
• identifying the correct model and cube view
• building a cube in SAS OLAP Cube Studio
• viewing the cube in SAS Web Report Studio, SAS Enterprise Guide, and Microsoft Excel
• viewing a cube

Report Customization in SAS Activity-Based Management OLAP

• identifying chart types and configurations
• customizing the Grid, Chart, and Cube Explorer views
• exporting to Excel
• copying an Explorer view to the Grid view

Custom Reports in SAS Enterprise Guide

• extracting report template data from your activity-based model and place it in a SAS data set
• formatting the data and using simple math to calculate a value
• generating a report with a graphics display from the report template data
• saving the process

Reporting and Refining SAS Activity-Based Management Data in Other SAS Reporting Applications

• creating an information map from SAS Activity-Based Management data
• refining information map data for display in SAS Web Report Studio
• creating a new report in SAS Web Report Studio

Deploying Reports and Cubes with the SAS Information Delivery Portal

• accessing the SAS Information Delivery Portal
• searching for stored processes, information maps, and reports
• modifying a cube and generating a report

ABRC72.