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.

Hyperion Essbase 9.3.1: Deploy Aggregate Storage Databases

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

To handle today's business issues, you need analytics with depth. Aggregate storage extends your analytical environment by enabling Essbase outlines with millions of members. Whether deployed as standalone applications or combined with block storage, aggregate storage can help you deliver industrial strength analytics.

This course will give you a close look at aggregate storage features and arm you with practical examples to make your development job easier and more effective.

Learn To:
  • Recognize when to deploy aggregate storage, block storage, or a combined solution
  • Convert block storage to aggregate storage
  • Create, load, and pre-aggregate aggregate storage databases
  • Employ database partitioning in combined block/aggregate storage solutions
  • Write member formulas using MDX
  • Build time intelligent models for enhanced reporting

* Consider registering for Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases, if a convenient 9.3.1 class is not available.
 
Oracle Certified Training Course   Oracle Training Savings
 

Compétences acquises
 

  • Differentiate between block storage and aggregate storage databases

  • Create aggregate storage databases

  • Perform management tasks for aggregate storage databases

 

  • Partition block and aggregate storage databases

  • Create member formulas with MDX

  • Build time intelligent outlines

Qui peut en profiter
 

  • Application Developers

  • Business Analysts

  • Business Intelligence Developer

 

  • Database Administrators

  • Database Designers

  • Developer

Préalables
 

  • Knowledge of Microsoft Windows

  • Familiarity with Essbase Administration Services Console

 

  • Working knowledge of block storage databases

  • Hyperion Essbase Fundamentals, Hyperion Essbase Bootcamp, or equivalent experience
 
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-EB-DEPLOY
Format: Formation en classe avec formateur
Durée: 3
Certifié par: Oracle
Frais d’inscription (CAD): 3,090$
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
 

Hyperion Essbase 9.3.1: Deploy Aggregate Storage Databases Contenu détaillé
 
 
Essbase Overview
  • Hyperion Business Performance Management Overview
  • Hyperion Analytic Solution
  • Data Analysis Needs
  • Aggregate Storage Overview
Creating Aggregate Storage Databases
  • Aggregate Storage Outline Hierarchies
  • Designing Hierarchies
  • Converting Block Storage to Aggregate Storage
Loading and Aggregating Data
  • Loading Aggregate Storage Data
  • Data Aggregation
  • Designing and Running Aggregations
Managing Aggregate Storage Databases
  • Managing Tablespaces
  • Exporting Data
  • Data Compression
  • Optimizing Aggregate Storage Cache
  • Managing Outline Paging
  • Disk Space Management
  • Backing Up Aggregate Storage Applications
  • Aggregate Storage Database Statistics
Partitioning Overview
  • Partition Types
  • Partition Overlaps
  • Partition Design Choices
Creating Database Partitions
  • Outline Differences
  • Creating Partitions
  • Aggregate Storage Partition Designs
  • Creating Partitions for Write-back
  • Design Considerations
Creating Basic MDX Queries
  • MDX Overview
  • MDX Queries
  • Adding Comments to Queries
  • Identifying Dimensions and Members
  • Selecting Multiple Members
  • MDX Data Model: Tuples and Sets
  • Managing Multiple Sets
 
Converting Block Storage Member Formulas to MDX
  • Elements Common to Block Storage and MDX Formulas
  • Elements Unique to MDX Formulas
  • Function Return Types
  • Formula Conversion
  • Aggregate Storage Calculation Order
  • Block Storage Custom Functions and Macros
Creating Basic MDX Member Formulas
  • Member Formula Editor
  • MDX Help Documentation
  • Formula Design Considerations
  • Arithmetic Operators and Expressions
  • Outline Layer Reference Functions
  • Creating Mix Calculations
  • Deriving Variances
Time Intelligence Overview
  • Time Intelligence Wizard
  • Building time dimensions based on standard calendar templates
  • Member date ranges
Loading Data Mapped to Dates
  • Time-based data loads
  • Processing load files
Using Linked Attributes for Time Period Reporting
  • Linked Attributes Overview
  • Time period reporting
Employing MDX Date Functions
  • MDX date functions Overview
  • Performing date mathematics with MDX date functions
Creating Time Balance Calculations
  • Time Balance tags
  • Flow tags
  • Adding Time Balance tags to your database outline


  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