Uddannelsestilbud

IBM Cognos Cube Designer Design Dynamic Cubes (V10.2.2) - SPVC

Information

Pris kr 4.600  Ekskl. moms
Varighed: 2 Dage
Courseware : Included
Ref: J2A63G
Delivery Type Self Paced Training

Sessionsdatoer

På anmodning. Kontakt os venligst

Purchase

    BUY Now
    kr 4.600  Ekskl. moms

    Ekskl. moms

Disse oplysninger findes også beregnet for intra-virksomhedsuddannelsen. Tøv ikke med at kontakte os for at få flere oplysninger

Beskrivelse

IBM Cognos Cube Designer: Design Dynamic Cubes (V10.2.2) 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 dynamic cubes, and enabling end users to easily author reports and analyze data.



If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.



http://www.ibm.com/training/terms

Formål

Please refer to course overview.

Målgruppe

This intermediate-level course is for Data Modelers.

Forudsætninger

You should have:




  • Knowledge of dimensional modeling and design.

  • Experience using IBM Cognos Connection and Administration.

Program

Introduction to IBM Cognos Dynamic Cubes




  • Define and Differentiate Dynamic Cubes

  • Identify the Challenges of Very Large Data and how Dynamic Cubes resolves those issues

  • Examine dynamic cube characteristics

  • Examine dynamic cube requirements

  • Examine high-level architecture

  • IBM Cognos Dynamic Query

  • Review Dimensional Data Structures

  • Describe the dynamic cube process flow and lifecycle

  • Examine how dynamic cubes use caching



Create and Design a Dynamic Cube




  • Explore the IBM Cognos Cube Designer

  • Review the cube development process

  • Examine the automatic cube generator

  • The Manual Development Process

  • Examine Modeling Strategies



Deploy and Configure a Dynamic Cube




  • Deploy and publish a dynamic cube

  • Use the Hardware Sizing Wizard

  • Configuration and management of a published cube

  • Assign an Access Account

  • Examine query service administration tasks

  • Explore dynamic cube properties

  • Configure a dynamic cube to trigger a report

  • Run Administrative Commands with the DCAdmin Command Line Tool



Advanced Dynamic Cube Modeling




  • Identify advanced modeling techniques and caveats

  • Examine calculated members and measures

  • Model a relative time dimension

  • Explore Custom Relative Time

  • Explore the Current Period Property

  • Define Period Aggregation Rules for Measures

  • Create and Use Named Sets

  • Examine the Shared Dimension Property



Advanced Features of Cube Designer




  • Examine Multilingual Support

  • Define Parent-Child Dimensions (ragged hierarchies)

  • Refresh Metadata in an Existing Cube

  • Import Framework Manager packages into Cube Designer

  • Filter measures and dimensions



Optimize Performance with Aggregates




  • Examine aggregation in dynamic cubes

  • Identify types of aggregates (database and in-memory)

  • Examine user-defined, in-memory aggregates

  • Use Aggregate Advisor to identify aggregates

  • Use Automatic In-Memory Aggregate Optimization

  • Allocate memory for cache and aggregates

  • Explore the aggregate workflow

  • Explore the aggregate advisor

  • Use Slicers



Define Security




  • Overview of dynamic cube security

  • Types of Security

  • Examine Security Scope

  • Identify roles and capability requirements

  • Define Security Using Relational Database Tables

  • Use security filters to define hierarchy security views

  • Assign users and groups to security views



Model a Virtual Cube




  • Examine the benefits, requirements, and build process of virtual cubes

  • Explore virtual cube objects: dimensions and hierarchies

  • Examine virtual levels in merged hierarchies

  • Explore Currency Conversion Using a Virtual Cube

  • Apply security to virtual cubes

  • Publish a virtual cube



A: Overview of IBM Cognos BI




  • Describe the IBM Cognos Family

  • Identify the positioning of each component and studio in IBM Cognos BI

  • Examine the high level IBM Cognos BI architecture

  • Describe Cognos BI groups and roles

© 2018 VALit Aps - Arrow ECS. All rights reserved.