170 likes | 292 Views
Business Intelligence: Insight On Demand. Product Preview of Applix iTM1 8.1. Core iTM1 Products. iTM1 Server RAM-Based, Re-Calculation on Demand, Multi-Cube Architecture, OLAP Server Scalable, high performance
E N D
Business Intelligence: Insight On Demand Product Preview of Applix iTM1 8.1
Core iTM1 Products • iTM1 Server • RAM-Based, Re-Calculation on Demand, Multi-Cube Architecture, OLAP Server • Scalable, high performance • Incorporates Turbo Integrator for high performance data acquisition and management tasks • iTM1 Client • Spreadsheet add-in, allowing connection to TM1 Server • full use of interactive read-write applications • In-spreadsheet browser and iTM1 functions provide thebest integration
Core TM1 Products (contd.) iTM1 Perspectives • As per TM1 Client but also allowing development and administration of TM1 applications and servers • includes a Local TM1 Server. iTM1 Architect • Development and administration environment • As per TM1 Perspectives without spreadsheet integration
iTM1 v8: Major new functionality • Administration • Dynamic Subset & Views • Replication Views and Subsets • Engine Overhaul • New Dimension Editor • Rules Tracer • Deferred Updates • Drill Through • TI Improvements • Security Revamp • 64 bit Solaris and 64 bit Windows (8.1.1)
iTM1 8: Administration Objective: Provide a series of utilities to improve the management and administration of an application • Simple messaging & disconnect Clients • Browse Change Log; back out changes • Browse Message Log • Performance Statistics • Optimize Dimension Order
iTM1 8: Dynamic Subsets and Views Objective: Provide advanced user functionality in working with iTM1 • Dimension subsets defined as an MDX expression, rather than a fixed list • MDX recorder to help in definitions • Dimension based subsets (children of Europe) • Value based subsets based on views (top 10 etc.) • Available in cube viewer and ISB
iTM1 8: Replication Improvements Objective: Improve replication and synchronization to include more of the objects on the servers • Support of Views and Subsets • UI improvements
iTM1 8: Engine Overhaul Objective: minimize the server RAM requirements • Currently the activation of feeders takes 8 bytes per cell on loading the server • Now feeders will take 1 bit per cell on server loading – a 64 fold reduction in RAM • Memory will grow to 8 bytes per cell for every calculated cell actually used
iTM1 8: New Dimension Editor Objective: Improve ability to work with large dimensions • Subset editor navigation & selection • Element Order control
iTM1 8: Rules Tracer Objective: To ease rule building and improve user understanding • Facility to display how a cell is calculated: • Rule formula that applies • cells that are used in the calculation • Rule developers can check the application and validity of rule formulas • Users can understand how a value was arrived at • Additional feeder tracers help in developing and validating feeder rules.
iTM1 8: Deferred Updates Objective: Significantly improves concurrent read/write performance • Collects updates in RAM at the server prior to commitment • Perspectives automatically defers DBSends • Turbo Integrator can batch updates and apply in”one shot”
iTM1 8: Drill Through Objective: Provide the ability to navigate straight from a cube cell to another cube view or to a relational table • Controlled and managed by the server • Extensions to TI • Relational grid in ISB, Cube Viewer display results
iTM1 8: Turbo Integrator Improvements Objective: Provide even better data acquisition and management capabilities for enterprise integration • Processes now can be assigned Read access to non-Admin users • Processes may be reordered inside of chores • The same process can be used multiple times in a chore • TI process now displays a view of the data being processed • Users can now save incomplete processes • Better error handling; minor errors are skipped and put in a log
Security Revamp • Rationalize Security Organization • Security Refresh • Cell Level Security
iTM1 8.0.1: 64 bit Objective: Effectively tackle much larger applications; “out-ROLAP the ROLAPs” • Removes the current 3MB (NT) 4MB (Unix) hard memory limit • Theoretically unlimited memory • Only limited by the amount of RAM • HPUX 11, Solaris and Windows 64 supported (8.1.1) • Itanium chip based as required
Beyond Version 8 • Focus on usability, rather than just raw power • INTEGRA • Integration with iEnterprise & other star schema • Analytical applications
Integra 2.0 • OLEDB (Consumer MDX 2.0) Pull from SAP • Mirroring and Load balancing - Addresses scaling issues • Improve rules tools • Editor • Rules feeder- helper • Rules macros • Improve User interface • Editors (Security, Rules, Hierarchy) • TI function wizard • Replication UI • TI OBDC wizard