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
The following table shows some behavior changes:
14.00 Maintenance 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.
Teradata OLAP Connector
Teradata OLAP Server
Teradata Aggregate Designer
Nice to have access to ROLAP environment. I hope the creation of AJIs through Aggregate designer is easy.
Thanks and regards,
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.
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.
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?
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.
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
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.