Detailed Course Outline
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) • 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