Essbase ASO Implementation-Temas

Essbase ASO Implementation

Essbase Overview The Oracle Enterprise Performance Management System The Oracle BI Foundation Suite The Essbase analytic solution	Aggregate Storage Overview Aggregate storage key characteristics and design considerations Understanding the aggregate storage production cycle Creating aggregate storage outline hierarchies	Designing Data Descriptor Dimensions Understanding data descriptor dimensions Designing time, scenario, and accounts dimensions
Designing Business View Dimensions Understanding business view dimensions Using attributes in database design Designing primary and secondary hierarchies	Loading Data Understanding the aggregate storage data loading process Using data load buffers Loading data incrementally	Creating Reports with Smart View Understanding the Smart View architecture and user interface Connecting to data sources Working with shared and private connections
Aggregating Understanding the data aggregation process Optimizing aggregations Designing and running aggregations with the Aggregation Design wizard	Managing Aggregate Storage Databases Managing tablespaces Exporting aggregate storage data Optimizing data compression Managing storage caches Optimizing outline paging Understanding disk space management options Backing up aggregate storage applications Viewing database statistics	Creating Basic MDX Queries MDX Overview Understanding MDX formula components and structure Identifying dimensions and members in MDX Identifying tuples and sets
Creating MDX Formulas Using Member Formula Editor Creating mix calculations Using MDX conditional calculation tools Deriving variances	Time Intelligence Overview Understanding the benefits of time intelligence Establishing time intelligence in aggregate storage applications Using the Create Date-Time Dimension wizard	Building Time Intelligent Models Creating a date-time dimension Using standard calendar types Defining member date ranges
Loading Data Mapped to Dates Identifying date hierarchies Performing date-based data loads Using date-string formats	Creating Time Period Reports Identifying linked attributes Understanding periodic associations Creating linked attribute reports	Calculating Time-Based Metrics Understanding time dimension designs Creating analytics dimensions Calculating time-based metrics Using MDX date functions
Time Balance Calculations Using time balance tags Using flow tags	Partitioning Overview Identifying data transfer methods Understanding database partition types Identifying the best partition type to use Resolving partition overlaps Following partitioning guidelines	Creating Database Partitions Designing partitions Creating partitions Evaluating partition designs
Creating Custom Calculations Understanding the workflow for creating custom calculations Specifying calculation criteria Writing and executing custom calculations	Creating Allocations Understanding the workflow for creating ASO allocations Specifying allocation criteria Specifying allocation and rounding methods Executing allocations