Home Page Icon
Home Page
Table of Contents for
Scheduling a refresh of the cache (2/2)
Close
Scheduling a refresh of the cache (2/2)
by Christopher Yao, Carlos Ruiz, Steven Rogers, Chris McPherson, Skyla Loomis, Beth
IBM Cognos Dynamic Cubes
Notices
Trademarks
Preface
The team who wrote this book
Now you can become a published author, too
Comments welcome
Stay connected to IBM Redbooks
Chapter 1: Overview of Cognos Dynamic Cubes
Introduction to IBM Cognos Dynamic Cubes
High performance interactive analysis
Enterprise data warehouses for analytics
Data volumes and context in the Enterprise Data Warehouse
Architecture summary
Skillset requirements for IBM Cognos Dynamic Cubes
Modeling
Cognos administration
Infrastructure design
When to use Cognos Dynamic Cubes
System requirements
Comparison to other IBM cube technologies
Chapter 2: IBM Cognos Dynamic Cubes architecture
Dynamic cubes in the IBM Cognos environment
Dynamic cubes and the data warehouse
Modeling dynamic cubes
Dynamic cubes as data sources
Configuring dynamic cubes
Dynamic cube management
Virtual cubes
Aggregate Advisor
Dynamic cubes and the Dynamic Query Mode server
Dynamic cubes and report server
Dynamic cubes within the Dynamic Query Mode server
Cognos Dynamic Cubes caching
Result set cache
Expression cache
Member cache
Aggregate cache
Data cache
Dynamic cubes query processing
Metadata query processing in the Dynamic Query Mode server
OLAP query processing in the Dynamic Query Mode server
Using the database to evaluate set expressions
Management of Cognos Dynamic Cubes
Chapter 3: Installation and configuration of Cognos Cube Designer and Dynamic Query Analyzer
Introduction
Cognos Cube Designer operating requirements
IBM Cognos 10.2 Business Intelligence Server
IBM Cognos 10.2 Report Server
IBM Cognos 10.2 Framework Manager
Java Runtime Environment Libraries
Supported relational databases
Cognos Cube Designer supported operating systems
Cognos Dynamic Cubes hardware requirements for the BI Server
Installing IBM Cognos Cube Designer
Installing Dynamic Query Analyzer
Dynamic Query Analyzer installation requirements
Installation procedure (1/2)
Installation procedure (2/2)
Configuring Dynamic Query Analyzer
Chapter 4: Modeling dynamic cubes
Introduction to IBM Cognos Cube Designer
Working with Cognos Cube Designer
Launching Cognos Cube Designer
Creating a new project
The Cognos Cube Designer workspace
Creating calculated measures
Importing metadata
Exploring data using the Relational Explorer Diagram
Exploring data using the tabular data view
Creating a dynamic cube
Modeling dimensions
Relationships
Modeling levels
Member tree organization options
Modeling level keys
Parent-child dimensions
Calculated members
Modeling time dimensions for relative time
Using relative time
Slowly changing dimensions
Modeling slowly changing dimensions
Metadata discovery
Slowly changing dimension as a parent-child dimension
Modeling a slowly changing dimension in a regular dimension
Role-playing dimensions
Multi-grain fact scenarios
Aggregate cubes
Modeling aggregate cubes
Degenerate dimensions with matching level keys
Degenerate dimensions with matching join keys
Rolled-up dimensions
Parent-child dimensions
Custom aggregation
Slicers
Other modeling considerations
Automatic aggregate cube creation
Validation
Deploying dynamic cubes for reporting and analysis
Quick-deploy options in Cognos Cube Designer
Manually deploying a dynamic cube
Troubleshooting
Importing metadata
Publishing errors
Missing metadata
Refreshing metadata that changed in the database
Members
Missing members
Ellipses in the project viewer tree
The No Protocol message while running Cognos Cube Designer
Creating a sample cube model by using GOSLDW
Measures of gosldw_sales
Dimensions in the gosldw_sales cube
Time
Employee by region
Promotions
Order method
Retailers
Time (close date)
Time (ship date)
Branch
Product brand
Product name
Products
Creating a time dimension
Modeling for multi-grain scenarios
Chapter 5: Administering dynamic cubes
Adding and removing cubes from the QueryService
Adding a cube to the QueryService
Removing a cube from the QueryService
Starting, stopping, and monitoring cubes
Starting a cube
Stopping a cube
Monitoring cube state through metrics
Managing the cache
Setting up routing rules
Setting up redundant cube instances
Scheduling a refresh of the cache (1/2)
Scheduling a refresh of the cache (2/2)
Chapter 6: Virtual cubes
Overview of virtual cubes
Creating virtual cubes
Deploying virtual cubes
Manually merging source cube objects
Common use cases for virtual cubes
Time partitioning
Currency conversion
Multiple fact tables
Managing virtual cubes
Verifying virtual cube dependency
Starting the virtual cube
Stopping the virtual cube
Stopping the source cubes
Virtual cube considerations
Modeling considerations for virtual cubes
Caching and performance considerations
Chapter 7: Dimensional security
Overview of dimensional security
Security model
Security filters
Security views
Grant versus deny approaches to security
Visible ancestors
Example: Visible ancestors unnecessary
Example: Basic visible ancestor
Example: Combination of visible and granted ancestors
Examples: View merge impact on visible ancestors (1/2)
Examples: View merge impact on visible ancestors (2/2)
Secured padding members
Example: Secured padding member unnecessary
Example: Secured padding member needed at leaf level
Example: Secured padding members needed on multiple levels
Default members
Default member examples
Data caching
Calculated members
Merging of security views or security filters
Secured tuples
Example 1
Example 2
Example 3
Example 4
Example 5
Example 6
Example 7
Defining security in Cognos Cube Designer
Selecting the hierarchy on which to define the security filter
Creating security filters
Creating security views
Securing measures
Publish and start the cube
Applying security views
Verifying the security model
Chapter 8: Optimization and performance tuning
Performance implications of OLAP-style reports
Aggregate awareness in Cognos Dynamic Cubes
Overview of the Aggregate Advisor
Model-based analysis
Workload-based analysis
Running the Aggregate Advisor without considering workload information (1/2)
Running the Aggregate Advisor without considering workload information (2/2)
Running the Aggregate Advisor with considering workload information
Opening Aggregate Advisor results and viewing details (1/2)
Opening Aggregate Advisor results and viewing details (2/2)
Rerunning the Aggregate Advisor
In-memory aggregates
Applying in-memory aggregates
Loading in-memory aggregates into the aggregate cache
Monitoring aggregate cache hits
In-memory aggregate tips and troubleshooting
Database aggregates
In-database aggregate recommendations
Creating recommended database aggregates
Maintaining database aggregates
Monitoring database aggregate table hits
Database aggregates tips and troubleshooting
Cache Priming Techniques
Preloading the caches
Priming the caches
Cache size best practices
Scenarios for performance tuning
Cases for adjusting cache sizes
Cases for aggregates
Chapter 9: Dynamic cube lifecycle
Overview of the dynamic cube lifecycle
Analyze
Model
Deploy
Run
Optimize
Lifecycle across different environments
Mechanisms for moving dynamic cubes
Development
Test
Production
Best practices for deploying between environments
Keep a copy of the dynamic cube project file under source control
Use consistent data source, schema, and table names in all environments
Skip the optimize step in the development environment
Use a separate database for each environment
Include complete dimensional data in development environment
Make the test system similar to the production system
Chapter 10: Troubleshooting
Dynamic Query Analyzer
New Features
Configuring Dynamic Query Analyzer
Query execution tracing
Visualizing dynamic cube startup
Reviewing Cognos reports with Dynamic Query Analyzer
Reviewing the query execution trace
Subsequent run requests: Taking advantage of the result set cache
Confirming the role of caching
Reviewing Report SQL
Verifying changes to the BranchProfitByYear Report
Virtual cube query execution tracing
Dynamic cube QueryService logging
Dynamic cube query plan tracing
Aggregate matching
Common problems
Configuring Cognos Dynamic Cubes logging
Cube does not start
Unexpected data values returned
Cube loaded but relative time members are missing
Related publications
IBM Redbooks
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Scheduling a refresh of the cache (1/2)
Next
Next Chapter
Chapter 6: Virtual cubes
132
IBM Cognos Dynami
c Cubes
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset