ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases

Catégorie: Formation  Hyperion
Format: Formation en classe avec formateur
Autres formats:
 
 

This course shows you how to deploy aggregate storage databases in Oracle Essbase. You learn the fundamental differences between block storage and aggregate storage databases and requirements for database design and deployment. You learn how to convert existing block storage database outlines to aggregate storage and how to create aggregate storage databases. You also learn about database partitioning as it relates to aggregate storage databases and about MDX for building member formulas. You finish with an in-depth discussion of time intelligence. Exercises provide hands-on practice.

Learn to:
  • Leverage aggregate storage and block storage for a complete Essbase deployment
  • Create MDX member formulas
  • Create time-intelligent outlines
  • Create aggregate storage databases

* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.
 
Oracle Certified Training Course   Oracle Training Savings
 

Compétences acquises
 

  • Create aggregate storage databases

  • Perform fundamental management tasks for aggregate storage databases

  • Partition block and aggregate storage databases

  • Write member formulas with MDX

 

  • Build time-intelligent aggregate storage models

  • Implement time intelligence for time period reporting

  • Differentiate between block storage and aggregate storage databases

Qui peut en profiter
 

  • Business Intelligence Developer

  • Database Administrators

  • Database Designers

 

  • Developer

  • Technical Consultant
 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion Ce cours est donné par des formateurs certifiés Oracle.

Oracle University a nommé ExitCertified Partenaire de l’année 2011

Il y a une différence....découvrez-la.
Training Class Enrollment Ask A Question About This Training
Code: HY-ESS-DEPLOY
Format: Formation en classe avec formateur
Durée: 3
Certifié par: Oracle
Frais d’inscription (CAD): $contact
Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
No Course Dates Ce cours n'est pas prévu à l'horaire pour l'instant. Si vous êtes intéressé à suivre ce cours, utilisez le lien ci-dessous pour demander une date.
   
demander la date/l’emplacement demander de la formation sur place
 

Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases Contenu détaillé
 
 
Essbase Overview
  • Oracle's Enterprise Performance Management System
  • Oracle BI Suite Enterprise Edition Plus
  • Essbase Analytic Solution
  • Data Analysis Needs
  • Aggregate Storage Overview
Creating Aggregate Storage Databases
  • Aggregate Storage Production Cycle
  • Designing Aggregate Storage Outline Hierarchies
  • Designing Alternate Hierarchies
  • Converting Block Storage to Aggregate Storage
Loading and Aggregating Data
  • Loading Aggregate Storage Data
  • Data Aggregation
  • Optimizing Aggregations
  • Designing and Running Aggregations
Managing Aggregate Storage Databases
  • Tablespace Management
  • Disk Space Management
  • Exporting Data
  • Data Compression
  • Optimizing Aggregate Storage Cache
  • Optimizing Outline Paging
  • Partially Clearing Data
  • Backing Up Aggregate Storage Applications
Partitioning Overview
  • Data Transfer Methods
  • Database Partitioning
  • Partition Types
  • Partitioning Guidelines
  • Partition Overlaps
  • Partition Choices
Creating Database Partitions
  • Outline Differences
  • Creating Partitions
  • Aggregate Storage Partition Designs
  • Design Considerations
Creating Basic MDX Queries
  • MDX Overview
  • MDX Queries
  • Identifying Dimensions and Members
  • Selecting Multiple Members
  • MDX Data Model: Tuples and Sets
  • Managing Multiple Sets
 
Converting Block Storage Member Formulas
  • Elements Common to Block Storage and MDX Formulas
  • Elements Unique to MDX Formulas
  • Function Return Types
  • Converting Formulas to MDX
  • Aggregate Storage Calculation Order
  • Considerations for Custom Functions and Macros
Creating Basic MDX Formulas
  • Member Formula Editor
  • Accessing MDX Help Documentation
  • Creating Mix Calculations
  • Conditional Calculation Tools
  • Deriving Variances
Time Intelligence Overview
  • Time Intelligence in Aggregate Storage
  • About the Create Date-Time Dimension Wizard
  • Time Intelligence Benefits
Building Time Dimension Models
  • Creating Date-Time Dimensions
  • Supported Calendar Types
  • Date Ranges
Loading Data Mapped to Dates
  • Date Hierarchies
  • Date-Based Data Loads
  • Date-String Formats
  • Loading Time-Based Data
Creating Time Period Reports
  • Linked Attributes
  • Periodic Associations
  • Linked Attribute Mapping
  • Linked Attribute Mapping: Example
  • Creating Linked Attribute Reports
Calculating Time-Based Metrics
  • Time Dimension Designs
  • Creating Analytics Dimensions
  • Calculating Time-Based Metrics in Generic Time Designs
  • MDX Date Functions
Time Balance Calculations
  • Time Balance Tags
  • Flow Tags


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI