Feature list – timeXtender® 4 Version 4.4
Rule based data processing • Extraction • Validation • Transformation
Data quality control
• • • •
Checkpoints Integrity checking Warnings Errors
Multiuser environment
Advanced modeling features
• Multiple projects • Multiple concurrent users
Multiple data sources
• • • • • • • • •
Microsoft® SQL Server 2000 or higher Oracle®8 RDBMS or higher IBM® DB2 (UDB, iSeries, z/OS) Microsoft® Excel Plain text files Generic ODBC Microsoft® Dynamics NAV™ Native IBM® Informix® My SQL 5.1
Application specific adapters • Microsoft® Dynamics NAV™ • Microsoft® Dynamics AX™ • SAP adapter (alpha)
Flexible data load strategy • Incremental • Full
Comprehensive manual control
History and versioning
Data profiling and mapping Custom tables and fields Lookup fields Ragged dimensions Parent-child dimensions Slowly changing dimensions Multiple fact tables Custom rollups Unary rollups Unknown key values Data previews Custom data entry for missing values Select during preview
• Data warehouse • Project
Ease of use • Drag-and-drop GUI • Active Directory integration • Automatic XML project documentation
• Custom documentation • “Where used” traces for impact analysis • “ Depends on” traces for documentation and debugging
Scheduling • C onfigurable scheduling of single elements, multiple elements or entire projects
Cube Modeling
Process automation
• • • • •
Generation of SQL statements Generation of time dimensions Generation of OLAP cubes Project deployment and execution Notification of deployment and execution
Reverse engineering • Data warehouses • OLAP cubes
Deployment flexibility
• • • • •
Multiple data warehouse servers Multiple data marts Multiple OLAP servers Deploy on remote servers Configurable environments (Such as Dev., Test, Live) • Merge Deployment
Trace Diagrams
• Many to many dimensions • S upport for multiple languages on Analysis Services (translations) • Spreadsheet formulas • Function guides for MDX and VB scripts • Instant calculations in browse mode • Business Function Library • Cube and dimension browser • Advanced XMLA scripting • OLAP write back • OLAP user rights • OLAP KPIs • Drag and drop creation of dimensions and measures • Referenced dimensions
Microsoft® SQL Server Support
• Microsoft® SQL Server 2005/2008 • Standard and Enterprice editions • 32 and 64 bit support
Cube Store • Download solutions • Upload solutions
June_2010
• Synchronization of data sources • On-demand deployment and execution
• • • • • • • • • • • • •
Member of the Microsoft Data Warehouse Alliance
timeXtender ® is a dynamic and innovative Business Intelligence software house that develops the product timeXtender® - a SQL Server-based data warehousing and OLAP cube tool that requires no coding. timeXtender is also the creator of QuickCubes - predefined and easily deployed Business Intelligence solutions. A Microsoft Gold Partner since 2006, timeXtender reached a strategic milestone when it was named Microsoft ISV Partner of the year in Denmark in 2008. Headquartered in Denmark, with offices throughout Europe and in the USA, timeXtender is an international, partner- driven company. www.timextender.com © 2010 timeXtender®. timeXtender® is a registered trademark of timeXtender Holding. All other product names mentioned in this document may be trademarks or registered trademarks of their respective companies.