|
|
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
- Using an open SQL interface, the DecisionStream Connector for SAP R/3 can access all tables through the SAP Application Layer. Pre-built ABAP functions interpret and resolve the SQL code.
- 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.
|
|
|
