

What's new in 14.10 for Teradata OLAP Solutions
Teradata OLAP Connector (TOC), Teradata Schema Workbench (TSW), Teradata Aggregate Designer (TAD) and Teradata OLAP Server (TOS) 14.10 releases are now GCA. In addition to several key new features, this release adds Teradata OLAP Server which includes an XMLA engine that provides data access interaction between a client application and a Business Intelligence provider working over the Internet providing direct and optimized access to the Teradata ROLAP environment. Teradata OLAP solutions can now be deployed with more than just Excel as BI vendors support now includes arcplan and Tableau using TOC and SAP Business Objects through TOS. And for users who support multiple BI tools, they can now be deployed using the same Multi-Dimensional Model built on Teradata. In leveraging the same multidimensional model, all investments in optimization and performance are shared across the entire customer set of BI tool users. This ensures overall lower Total Cost of Ownership.
New General Product Features
- Teradata Database and TTU 14.10 Support
- Push-Down Calculations: Performance Improvement that removes the all-or-nothing restriction in the Push-Down feature that shipped in the 14.00.01 Maintenance release Imagine you have a base measure (Sum of Sales), a calculated measure that can be pushed down (Pushdown measure, which is a measure written using the MDX functions described in the maintenance release) and a calculated measure that cannot be pushed down (Un-pushable measure, one that falls outside the list of supported MDX functions as previously written).
The following table shows some behavior changes:
Query |
14.00 Maintenance Release |
14.10 release |
Pivot table requesting two values, Sum of Sales and Unpushable measure |
Nothing pushed down |
Sum of Sales pushed down, Unpushable measure not pushed down |
Pivot table requesting two values, Pushable measure and unpushable measure |
Nothing pushed down |
Pushable measure pushed down, unpushable measure not pushed down |
This behavior should be true in many scenarios, including when filters are applied, calculated members are used on rows, etc.
- Trusted Session connection support through SET QUERY_BAND
- Memory utilization in the MDX engine has been optimized for performance improvement when a hierarchy level owns many MEMBERS (40 or more)
- Long Database Column names (up to 128 characters versus 30) is now supported
Teradata OLAP Connector
- Support for Excel 2007, 2010 and 2013, Tableau 8.1 and arcplan 7.1
- Client Side Operating support includes Microsoft Vista, Windows 7 and Windows 8, Microsoft Server 2008, 2008R2 and 2012
- Key new Excel features supported (Updated PivotChart, Calculated Measure, Calculated Members, Drill Down/Up)
- Excel Advanced Features – Sub queries (Slicers, Drill Down/Up, Label/Value filtering)
- Visual Totals is now enabled. This means that the grand totals and sub totals in a pivot table now change whenever the filters on the screen change. So if you drill up, down, apply a slicer, apply a filter (label, value, whatever) – the grand totals and the sub totals reflect the values in view on the pivot table.
Teradata OLAP Server
- Support for SAP BO 4.1
- XMLA service hosted on JBoss 7.1.1 on Windows Server 2008 R2 and 2012
Teradata Aggregate Designer
- Teradata Schema Workbench, Teradata OLAP Connector and Teradata OLAP Server 14.10 Support
- Added SQL Server 2012, COGNOS 10.2 Schema Support
- Support for Microsoft Windows 8 and Microsoft Server 2012 (excluding JRE 1.7)
- Added support for MIN and MAX aggregation types
- Mismatched Data Type Measure Overflow check
- Explorer option to change DBQL Database Name and Table Mapping