Cognos Data Manager (DecisionStream)

Overview

Enable rapid deployment of business intelligence solutions. 

Cognos DecisionStream improves your performance

• Report-ready operational data—DecisionStream ETL (extraction, transformation, and load) software lets you unite disparate data into an integrated BI foundation to deliver the reports and analysis that make operational data available for timely reporting.
• Increased data confidence—dimensional data marts deliver a consistent, accurate, and reusable data foundation by conforming key business dimensions such as time, product, and customer to enable reporting across business areas.
• Fast BI delivery—an intuitive visual environment lets you design your data framework quickly and easily without code generation. It also enables quick BI delivery by generating all the metadata required to develop and maintain a BI environment.

Product Highlights

• Dimensional data marts organize your data by subject area (sales, finance) and by data category (customer, product).
• Multi-platform, server-based ETL engine processes large volumes of data in short update windows with minimal hardware investment.
• Intuitive, graphical interface makes transformation processes quick and easy for the user.
• Flexible, dimensional framework adapts to business changes and can scale up from a department solution to an enterprise platform.
• Complete integration with Cognos world-leading analysis, reporting, dashboarding, and scorecarding software for business intelligence.

Features and Benefits

Architecture

• Working within existing data architectures, the pipelined transformation engine reads the data in a single pass, delivering high throughput with minimal hardware investment.
• From any client machine, process builds or jobs on any server machine located in the network using Web Services.

Administration

• DecisionStream integrates with source control systems, promotes or shares components from environment to environment, and performs component impact analysis.
• For any build or job, 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 regardless of where the execution takes place.

Dimensional

• Gain more than just Star Schema deliveries:
• Automated surrogate management.
• Automated delivery of conformed dimensions and facts.
• Automated support for slowly changing dimensions.
• Automated hierarchy definitions and validation.
• Automated late arriving facts and dimensions.
• The software organizes common descriptors such as customer, time, and location into dimension tables and places measures into fact tables. Distributed data sources are integrated into a consistent, enterprise-wide view.

Ease of use

• Prototype and test warehousing solutions prior to deployment.
• Create a JobStream to manage the data integration process in a drag-and-drop environment.
• Use Interactive wizards to develops builds in rapid time.

Integration

• Selectively choose what facts and dimensions are to be delivered to the Cognos ReportNet environment (Framework Manager) to enable instant reporting from the reporting structure.

In support of Series 7 reporting and analysis, create default Cognos Architect models, reporting catalogs, PowerCubes, and key reports optimized for each data mart.