Join the New Business Intelligence
REVOLUTION DEMAND SMARTER, FASTER, EASIER BUSINESS INTELLIGENCE
KEY FEATURES - of timeXtender. Valid from version 4.5 ŠtimeXtender
Features you need for your BI project and get with timeXtender - but not with the standard Microsoft SQL Server Toolset.
Trace - Complete trace of a single entity, both back and forwards - Works all the way from data source to cube
Multi-environment - Automated deployment across multiple environments, like development, test and production - Complete trace of different versions deployed on each environment
ERP adapters - Intelligent connection to MS Dynamics NAV, MS Dynamics AX and SAP R/3 - Gives access to application specific information and automates multiple companies etc. - Please refer to separate product description for in-depth information on each adapter
MDX code automation - MDX and VB function library with syntax template - IntelliSense - Instant result for efficient prototyping
Business Functions – reuse of MDX based on parameters - Wrap commonly used calculations for easy reuse - Parameterize calculations for easy maintenance - Hide complexity for business users - Easy reuse across installations/projects using import/export
Documentation - Fully automated generation of Documentation, including full version control to ensure that the documentation corresponds to the deployed version - Option to add comments to all elements in the project - Template can be modified and the documentation comes as a hyperlinked PDF document - Valid for IT Audit under SOX
Version control - Complete version control for every save of a project and every deployment - Each version can be opened - Gives the option to roll back to a prior version
www.timextender.com
Join the New Business Intelligence
REVOLUTION
DEMAND SMARTER, FASTER, EASIER BUSINESS INTELLIGENCE
2 : Key Features - of timeXtender. Valid from version 4.5
ŠtimeXtender
CubeStore - Access to wide range of pre-built solutions (horizontals and verticals) - Can be downloaded directly into timeXtender - Up and running within hours - Downloaded solution easily customizable and extendable
Reverse engineering - Reverse of an existing OLAP database from MS SQL 2000 and newer - Reverse of an existing DW database from MS SQL 2000 and newer
Merge deployment on OLAP - Multiple projects can be deployed to the same SSAS database - Bypasses limitation in the native SQL tools
Advanced XMLA scripting - Enhances the standard XMLA scripting language - Supports modifications to minor SSAS objects using inline scripting - Supports XPATH queries for XML manipulation
Built-in rule based data quality engine - Implicit and explicit primary- and foreign key constraint enforcement - Enforce threshold values - Row or value based checkpoints and notifications
Target based incremental loading - Supports configurable handling of insert, update and delete - Configured on a per table basis - Significant performance boost for data sources w/o native support for incremental
MS SQL Server functionality that has been expanded and optimized in timeXtender for better performance and ease of use.
Moving of projects as XML between installations - Move or copy entire solution between installations/customers/environments - Entire solution can be moved within minutes - Works across different SQL Server versions/editions
Consolidation tables - Visual builder for GL accounts dimension (balance sheet, income statement) - Include custom rollup formulas (dimension calculations) - Generic usage for mapping any structure into reporting format
Incremental loading - Supports numeric and/or datetime based values for inserts and updates - Support for dirty reads (avoid gaps in data caused by long-running transactions) - Implemented on a per table basis within minutes
www.timextender.com
Join the New Business Intelligence
REVOLUTION
DEMAND SMARTER, FASTER, EASIER BUSINESS INTELLIGENCE
3 : Key Features - of timeXtender. Valid from version 4.5
©timeXtender
Type-2 dimensions - Simple and fast implementation - Schema change engine handles structure changes over time
Time dimensions - Range based with fixed or dynamic start and end dates - Can be combined with custom calendars
Graphical environment - saves 50% - 80% of the development time - Limited need for SQL skills - ERP consultants can now do BI implementation
Write back - Write back enabled with single click - Write back partition automatically maintained as structure changes over time
Distributed data sources - One selection across identical data sources - Maintain multiple identical data sources in one process - Add new data sources on the fly
Partitions - Multiple table partitions on staging and data warehouse - Partition templates ensure easy reuse of common partition settings - Table partitions automatically aligned with cube partitions
Automated performance optimization Hash-bytes
Compressions - Supports row- and table based compression on both staging and data warehouse - Implemented automatically based on table classification - Can be manually configured in advanced mode
Indexes - Automatic index creation
Look-ups - Graphical implementations of lookups - Automated relations generation
Multi-threading
© 2010 timeXtender®. timeXtender® is a registered trademark of timeXtender Holding. Microsoft and SQL Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. All other product names mentioned in this document may be trademarks or registered trademarks of their respective companies.
www.timextender.com