Teradata OLAP Connector (TOC), Schema Workbench (TSW) and Aggregate Designer (TAD) 14.00 Maintenance releases have now been posted for download. In addition to several key fixes, this maintenance release includes a new TOC feature that allows function, method, and operator calculations to be applied in the underlying Teradata Database rather than on the client system. These calculations are known as pushdown calculations.
The Pushdown system is an evaluation method that allows the entire dataset returned by an MDX query to be evaluated all at once, instead of the traditional Cell-by-Cell (Context) evaluation.
The Functions, Methods, and Operators will fall under two categories: those that are eligible for Pushdown on their own, and those that are only eligible for Pushdown when found under another function eligible for Pushdown. Currently all of the operators eligible for Pushdown fall under the former category, and all of the methods eligible for Pushdown fall under the latter category.
The functions and operators listed below are eligible for Pushdown and can be the calculated measure expression's outermost function, as they return values. These functions include:
The functions and methods listed below are also eligible for Pushdown; however, since these functions and methods do not return Values, they are only eligible for Pushdown when found as parameters of other functions eligible for Pushdown. The functions and methods eligible for Pushdown only when specified as parameters to other functions eligible for Pushdown include:
For more information on pushdown, follow the link below
Where can I find TOC, TSW and TAD for download? I'm working in a POC and need to integrate with Tableau 8.0.5
Typically the only requirement on our part before downloading the TOC/TSW/TAD software is taking the implementation training. The course numbers are
When Complete send me an email. More details for TOC/TSW/TAD are available through the link below including access to demo data.