This course provides participants with introductory to advanced knowledge of how to model metadata for predictable reporting and analysis results using IBM Cognos Cube Designer. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data.
After completing this course, students will be able to:
Introduction to IBM Cognos Dynamic Cubes
Create and design a Dynamic Cube
Deploy and configure a Dynamic Cube
Advanced Dynamic Cube modeling
Advanced features of Cube Designer
Optimize performance with aggregates
Define Security
Model a virtual cube
Introduction to IBM Cognos Analytics (Optional)
Zielgruppen
Data Modelers
Vorkenntnisse
Knowledge of dimensional modeling and design. Experience using the IBM Cognos Analytics portal and Administration.
Detail-Inhalte
1: Introduction to IBM Cognos Dynamic Cubes
Define and differentiate Dynamic Cubes
Dynamic Cubes characteristics
Examine Dynamic Cube requirements
Examine Dynamic Cube components
Examine high level architecture
IBM Cognos Dynamic Query
Review Dimensional Data Structures
Dynamic Cubes caching
2: Create and design a Dynamic Cube
Explore the IBM Cognos Cube Designer
Review the cube development process
Examine the Automatic Cube Generation
Manual development overview
Create dimensions
Model the cube
Best practice for effective modeling
3: Deploy and configure a Dynamic Cube
Deploy a cube
Explore the Estimate Hardware Requirements
Identify cube management tasks
Examine Query Service administration
Explore Dynamic Cube properties
Schedule cube actions
Use the DCAdmin comment line tool
4: Advanced Dynamic Cube modeling
Examine advanced modeling concepts
Explore modeling caveats
Calculated measures and members
Model Relative Time
Explore the Current Period property
Define period aggregation rules for measures
5:Advanced features of Cube Designer
Examine multilingual support
Examine ragged hierarchies and padding members
Define Parent-Child Dimensions
Refresh Metadata
Import Framework Manager packages
Filter measures and dimensions
6: Optimize performance with aggregates
Identify aggregates and aggregate tables
In-memory aggregates
Use Aggregate Advisor to identify aggregates
User defined in-memory aggregates
Optimize In-Memory Aggregates automatically
Aggregate Advisor recommendations
Monitor Dynamic Cube performance
Model aggregates (automatically vs manually)
Use Slicers to define aggregation partitions
7: Define Security
Overview of Dynamic Cube security
Identify security filters
The Security process - Three steps
Examine security scope
Identify scope rules
Identify roles
Capabilities and access permissions
Cube security deep dive
8: Model a virtual cube
Explore virtual cubes
Create the virtual cube
Explore virtual cube objects
Examine virtual measures and calculated members
Currency conversion using virtual cubes
Security on virtual cubes
A: Introduction to IBM Cognos Analytics (Optional)
Trainings Übersicht
Rabatte, Aktionen und Förderungen
Lighthouse Expert Series
Lernformen
Feedback
Garantie
Hotels
Restaurants
Test Center
Dig-CERT
IT-Zertifizierungen für Schulen
Microsoft
Aruba
Amazon AWS
LPI
ITIL
Citrix
Cisco
Red Hat
VMware
Raum Miete
Videoproduktion
Job-Screening
Job-Matching
Über ETC
Qualität
Standorte & Öffnungszeiten
Team
Karriere
Nachhaltigkeit
Presse
FAQ
Benefits
Newsletter
Microsoft Gold Learning Partner
