Hyperion Essbase 9.0 New Features

Seminarziel

This course is designed to give you a comprehensive look at the new features of Analytic Services and Describe the role of Analytic Services within the BI+ framework of analysis. Expand the scope and size of areas of analysis in its domain using Hyperion Business Intelligence Platform, Analytic Services (formerly Essbase). Exercises provide hands-on practice.

Zielgruppe

Datenbankadministratoren, Datenbankdesigner, Data Warehouse-Administrator

Seminarinhalte

o Describe the role of Analytic Services within the BI+ framework of analysis o Utilize Administration Services Console to complete typical tasks of administration and design o Describe Analytic Services server and database enhancements o Convert an ESSCMD script to MaxL o Manage outlines containing duplicate member names o Create database triggers to monitor database changes o Explain the latest updates to Analytic Services security o Create, load, and aggregate an aggregate storage database o Describe the latest enhancements to aggregate storage databases o List the elements of an MDX query o Construct a basic MDX query o Illustrate office integration features offered by Smart View o Demonstrate the new features of Visual Explorer
Sachgebiete:

System 9/Analytic Services Overview - Analytic Services Overview - Managing Analytic Services with Administration Services Console

Server, Database, and Security Enhancements - Designing Unicode Mode Applications and Applying Substitution Variables - Converting ESSCMD Scripts to MaxL and eLicensing Overview - Developing and Testing Applications with Multiple Agent Support - Managing Outlines Containing Duplicate Member Names - Migrating Applications Across Servers with Migration Wizard - Creating Database Triggers and Performing Explicit Database Restructures - Applying Metadata Security by Using Filters/ External Authentication - Migrating Users from Native Security to Shared Services Security
Data Scalability Through Enterprise Analytics - Enterprise Analytics Overview - Converting Block Storage Databases to Aggregate Storage Databases - Creating, Loading, and Aggregating Aggregate Storage Databases - Creating Aggregation Scripts with Aggregation Design Wizard - MDX Overview - Creating MDX Queries - Converting Member Formulas to MDX
Excel Reporting Enhancements - Smart View Overview - Working with Smart View - Visual Explorer Overview - Improving Analysis with Visual Explorer Enhancements

Voraussetzungen

- Working experience with Essbase 6.5 or later - Familiarity with Microsoft Windows and Excel

Hinweis

Empfohlene weitere Ausbildung:"Hyperion Essbase 9.0: Deploy Aggregate Storage Databases"

Inhaltlich verwandte Kurse:
"Hyperion Essbase 9.0 For System Administrators"
"Hyperion Essbase 9.0 Fundamentals"