What's new in 14.10 for Teradata OLAP Solutions

Tools
Tools covers the tools and utilities you use to work with Teradata and its supporting ecosystem. You'll find information on everything from the Teradata Eclipse plug-in to load/extract tools.
Teradata Employee

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
13 REPLIES

Re: What's new in 14.10 for Teradata OLAP Solutions

Nice to have  access to ROLAP environment. I hope the creation of AJIs through Aggregate designer is easy.

Thanks and regards,

Raja

Teradata Employee

Re: What's new in 14.10 for Teradata OLAP Solutions

Teradata Aggregate Designer is a productivity tool used to design, validate, recommend and create AJI's to support performance optimization.  The Explorer option in this tool can be used to further optimize AJI's once deployed. 

N/A

Re: What's new in 14.10 for Teradata OLAP Solutions

what is the alternative of orcale package in teradata??

Teradata Employee

Re: What's new in 14.10 for Teradata OLAP Solutions

Not sure what was meant by orcacle package in Teradata? In an attempt to clarify 

Teradata OLAP Connector is a client-side MDX engine that provides direct and optimized access for OLAP/MDX clients like Excel PivotTables, Tableau and arcplan directly from Teradata in a ROLAP environment.  This would replace the more traditional MOLAP solution where data is extracted from the warehouse to an OLAP client or middle-tier server.  It's a more effective approach to supporting business users who require multidimensional database access.

Re: What's new in 14.10 for Teradata OLAP Solutions

How does this work with a microstrategy reporting solution?  We struggle with generated sql bogging down teradata sometimes - ideally pre-aggregation would help, but if data is in MDX, teradata olap might solve our problem?

Teradata Employee

Re: What's new in 14.10 for Teradata OLAP Solutions

Today the OLAP Connector is certified for use with Excel and by Tableau and arcplan.  OLAP Server is certified by SAP BO Analysis for OLAP.  Neither of these solutions has been certified by MSI.  You are coorect in that if it were certified, you could leverage Teradata Aggregate Designer within the solution.

Re: What's new in 14.10 for Teradata OLAP Solutions

IS there a way to show MoM report in OLAP. What I am looking for is to select Date in both column and row and it should show me the difference from Month to Month

Teradata Employee

Re: What's new in 14.10 for Teradata OLAP Solutions

There is a way to present MoM report defining calculated measure in MDX with Schema Workbench.

One of example with leaf level = month would be;

(Time.[Calendar Time].CurrentMember, [Measures].[Sales])

- (Time.[Calendar Time].CurrentMember.PrevMember, [Measures].[Sales])

This will aggregate Sales per month and compare with previous and current.

This example is available at Schema Workbench package as a sample schema.

Re: What's new in 14.10 for Teradata OLAP Solutions

Hi Team,

Please let me know the  best approach to clear the  BASIC  level certification TE0-141?

Regards,

Saurabh