Dimensional ETL for data warehousing

Cognos 8 platform for performance management

     Data Integration
Click the thumbnail for a closer look at dimensional ETL for data warehousing.

 

Flexible data sourcing capabilities are a key component of the Cognos 8 platform.  Cognos, an IBM company, provides open data access that enables access to data wherever it resides using published interfaces across transaction systems, warehouses (relational and OLAP), flat, legacy, or modern sources.

Cognos ETL is an enterprise-wide solution designed for high performance information access. It optimizes data merging, extraction, transformation, and dimensional management to deliver data warehouses ready for business reporting and analysis.

Dimensional ETL is a key component of the Cognos 8 platform, which provides an enterprise class foundation for all performance management needs.

Dimensional ETL

  • Patented automated dimensional management.
  • Multi-platform, server-based engine processes large volumes of data in short update windows with minimal hardware investment.
  • Working within existing data architectures, the powerful pipelined transformation engine reads the data in a single pass, delivering high throughput.
  • Delivers key metadata to the Cognos 8 metadata environment.
  • Provides read access to all modeled data in the Cognos 8 metadata environment.

Unique dimensional framework

  • Delivers data warehouses that consist of coordinated data marts to provide conformed dimensions and facts that are shared across subject areas.
  • Delivers a consistent, accurate, and reusable data foundation by conforming key dimensions such as time, product, and customer to enable reporting and analysis across business areas.
  • Flexible dimensional framework adapts to business changes and can scale up to an enterprise solution.
  • Automated dimensional management capabilities:
    • Surrogate key management for dimensions and facts.
    • Delivery of conformed dimensions and facts.
    • Support for slowly changing dimensions.
    • Late arriving facts and dimensions.
    • Hierarchy definitions and validation.
    • Provides easy interface for processing ragged, unbalanced and recursive hierarchies often required in BI solutions.

Integration with IBM Cognos 8 Planning Data

  • Integrates IBM Cognos 8 Planning data for write back to your data warehouse.
  • Extends BI capabilities to include planning data with your actuals.

Administration

  • Integrates with source control systems, promotes or shares components from environment to environment, and performs component impact analysis.
  • From any client machine, process builds on any server located in the network using Web services.
  • For any build, see in a graphical environment how it has performed over time by reviewing log files and analyzing statistics or view any current process as it executes.

Easy to use

  • Intuitive graphical environment enables:
    • Rapid development and deployment.
    • Merging of heterogeneous data sources.
    • Drag and drop capabilities.
    • Easy management of projects.
    • Data profiling and quality checking.
  • Iterative development environment results in short implementation cycles.
  • Multi-developer support.
  • Interactive wizards help you to quickly develop builds.

Additional Resources:


Value from the Cognos 8 Platform
White Paper
The Cognos 8 platform provides an open, enterprise-class platform as the foundation required to address performance management needs across the organization. Underpinning Cognos performance management products, it delivers complete, consistent access to information; broad system management; and is built on a modern, service-oriented architecture.
Read Now
The Importance of Open Data
White Paper
Read how the Cognos open data strategy for business intelligence lets you consolidate data from any source, with any latency, to create a single business view of your performance.
The Right Architecture for Business Intelligence: The Foundation for Effective Enterprise BI
White Paper
Read why the right architecture is a key factor in successful BI deployments and how the single, open IBM Cognos 8 BI architecture can reduce IT workload, improve productivity, and make better use of your IT budget.
IBM Cognos 8 BI version 8.3 - What's New Demo
Online Demo
See Transformer, express authoring, personal alerts, and the new system administration console.
New Features in IBM Cognos 8 BI version 8.3
Online Demo
See Transformer, express authoring, personal alerts, and the new system administration console.
Value from the Cognos 8 Platform
White Paper
Deliver performance management across the organization with the Cognos 8 Platform.
Contact Sales