B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)

2 Days

12 CPD hours

Data Modelers

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.

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

Create & 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

Deploy & 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

Advanced Dynamic Cube Modelling

• 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

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

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

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

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

Introduction to IBM Cognos Analytics

• Define IBM Cognos Analytics
• Redefined Business Intelligence
• Self-service
• Navigate to content in IBM Cognos Analytics
• Interact with the user interface
• Model data with IBM Cognos Analytics
• IBM Cognos Analytics components
• Create reports
• Perform self-service with analysis and Dashboards
• IBM Cognos Analytics architecture (high level)
• IBM Cognos Analytics security
• Package / data source relationship
• Create Data modules
• Upload files

Additional course details:

Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.