1 / 16

Data Manager

Data Manager . Business Intelligence Solutions. Data Mart and Data Warehouse Data Warehouse Architecture Dimensional Data Structure Extract, transform and load (ETL) Extract Transform Load. OLTP. OLTP. DATA MART. DATA. DATA. +/-. ERP. TEXT. x/y. F(x). F(x).

eugene
Download Presentation

Data Manager

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Manager Business Intelligence Solutions

  2. Data Mart and Data Warehouse • Data Warehouse Architecture • Dimensional Data Structure • Extract, transform and load (ETL) ExtractTransform Load OLTP OLTP DATA MART DATA DATA +/- ERP TEXT x/y F(x) F(x)

  3. IBM Cognos Data Manager • Extract operational data from multiple sources (both relational and non-relational) • Merges and transforms the data to facilitate enterprise-wide reporting, analysis, and performance management • Delivers the transformed data to coordinated data marts that make up the data warehouse • Can create metadata for use with Cognos 8 BI tools such as Query Studio and Analysis Studio and also can be easily deployed and scheduled using Cognos BI.

  4. Key Features 1. Automated tasks and processes Data Manager automates many of the complex process associated with data mart dimension and fact table creation and management, without the need for manual coding. • Surrogate key management for dimension and fact tables Data Manager can generate the surrogate key for the fact table using the business key. surrogate key business key

  5. Surrogate key of the dimension table can be defined during the dimension build. set up surrogate key in dimension build

  6. Support for slowly changing dimensions(SCD) Example of the SCD implementation from Granite dimension build:

  7. Late arriving Fact and Unmatched members .

  8. Hierarchy definitions and implementations A hierarchy is a particular view of a business dimension which organizes the structure data into levels that represent parent-child relationships. Each hierarchy can have as many levels as you require. • Provide easy interface for processing ragged, unbalanced and recursive hierarchies • Unbalanced hierarchies have leaf nodes at more than one level with the parent of every member coming from the level immediately above. Balance an unbalanced hierarchies YEAR QUARTER MONTH DAY

  9. Ragged hierarchies contain members that have parents at a level higher than the immediate parent level Example of a ragged hierarchy • Parent-Child Relationships – Recursive Hierarchies Example of Create recursive recursive hierarchies using hierarchies data manager

  10. Customized Refresh strategies in the Fact build Example of customized refresh types in a fact build

  11. 2. Referential integrity validation Data Manager reference explorer validates hierarchies within dimensions such as parent child relationships, multiple parents and foster children, so issues can be resolved before data is loaded into the warehouse.

  12. 3. Scalable Architecture Data Manager dimensional ETL provides flexible and responsive capabilities. An innovative dimensional reference model allows the coordination and management of data marts of all shapes and sizes and across many different platforms. Data Manager can use multiple processors, one processor for each job. Example of jobstream with parallel jobs.

  13. 4. Crafting an event process • A JobStream can multi-task events and allow commands to be executed in a parallel or serial manner. Example of a JobStream in a serial manner

  14. The developed JobStream can be published as Data Movement tasks into the IBM Cognos BI production environment, where they can be added to jobs and be scheduled for execution. Example of publish JobStream as Data Movement task Schedule a job in Cognos

  15. 5. Easy deployment Data Manager provides the ability to package components and easily move them from environment to environment and test functions and scripts as they are developed in the same environment.

  16. Q & A

More Related