![]() |
I've a data in the following format -
31 Jul 2016
| 2 comments
,
|
![]() |
Hi All, SELECT A.Dateid A.Product Type, A.Region, sum(B.Revenue),
28 Mar 2016
| 4 comments
,
|
![]() |
Dear All, Need help with below situation....
12 Nov 2015
| 2 comments
,
|
![]() |
This article is to announce the GCA of Teradata OLAP Connector (TOC), Teradata Schema Workbench (TSW) and Teradata OLAP Server (TOS) 15.10 releases. The Teradata OLAP Connector/Server provides additional options for Teradata customers to provide multidimensional database access to their business users. No additional hardware or infrastructure to purchase or maintain, no need to extract data from the data warehouse and the data access is secured through Teradata Roles and Profiles.
09 Sep 2015
| 4 comments
,
|
![]() |
This presentation demystifies usage of OLAP Analytics function for TD 15.0 and previous releases.
15 Oct 2014
,
|
![]() |
Hi,
29 Aug 2014
| 3 comments
,
|
![]() |
Hi,
17 Jul 2014
| 3 comments
,
|
![]() |
The Teradata Schema Workbench product provides a utility program that facilitates the proper definition and configuration of the metadata repository database (BIM_REPOSITORY) and associated tables required by the Schema Workbench, Teradata OLAP Connector and Teradata OLAP Server products. While it is possible to use tools such as Teradata Studio or Teradata SQL Assistant to manually define and configure the metadata repository, it is strongly advised that you utilize the Schema Workbench Toolbox.
12 Feb 2014
| 2 comments
,
|
![]() |
Introduced in the 14.10 OLAP Solutions release, Teradata OLAP Server provides an XMLA service hosted on JBoss 7.1.1 to provide data access interaction between SAP BusinessObjects (BO) 4.1 and the Teradata ROLAP environment. The Teradata OS solution requires deploying one or more Web service WAR files to the JBoss deployment environment. We have recently introduced a toolbox to facilitate the deployment and configuration of these Web services.
12 Feb 2014
| 4 comments
,
|
![]() |
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 applicat
13 Nov 2013
| 13 comments
,
|
![]() |
This webcast describes how you can leverage Essbase and Teradata Database technologies to improve your analytical application environment.
09 Oct 2013
,
|
![]() |
I am coding a SQL ( and I know a solution which is working). However I want to fix an alternative code. The code intents to find the first monday after the last friday of the last month( Here I have taken sample date of last day of 2013, otherwise it is a generic query and you can replace the '2013-12-31' by date)
18 Sep 2013
| 1 comment
,
|
![]() |
Hi!
04 Sep 2013
| 5 comments
,
|
![]() |
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.
05 Apr 2013
| 2 comments
,
|
![]() |
I've run into an issue with a rollup I am trying to do and was wondering if anyone has any ideas on how to do it in as few steps as possible.
24 Jan 2013
,
|
![]() |
It is believed that the computer called Deep Thought in the famous Douglas Adams' novel, “The Hitchhiker’s Guide to the Galaxy,” used Excel in the last step of figuring out the meaning of life. It is too bad Deep Thought couldn’t access the data in Teradata Database and let Teradata do the analytics because it would've figured out the meaning of life much sooner.
11 Dec 2012
,
|
![]() |
|
![]() |
Following is the data I currently have DateTime User Number
22 Mar 2012
| 6 comments
,
|
![]() |
Hi, Column C is explained as follows: Ordering by Column A ASC I want to replicate the value od Column B for all succeeding rows until a Non-Null value is met, then start again.
31 May 2011
| 2 comments
,
|
![]() |
I am trying to create a view that returns aggregate results using OLAP functions. My intention is for the view to return the aggregates based on the data included in the where clause within the select statement that queries the view. However, what I am finding is that the aggregates are computed using all rows in the tables and not based on the Where clause in the Select statement. Here’s a quick test:
10 May 2011
,
|
![]() |
Hi, I have a SQL problem that I have solved using an OLAP function but I am wondering if there is a better way to do it - more elegant with potentially better performance. Here is the essence of the problem. Each person must take a test once per day over a specified period of time. They may take the test more than once per day, but must take the test at least once. During the course of the day they can also move around to different rooms. The data would look something like this for one person: Person_Name Location Test_Date Test_Time
08 Nov 2010
| 2 comments
,
|
![]() |
The Teradata Database offers a unique native capability, the Aggregate Join Index (AJI), to help support multi-dimensional Business Intelligence solutions. An AJI is an aggregated result set saved as an index in the database. The AJI will be used automatically by the Teradata Optimizer when like columns and aggregates are made frequently within a query
26 Jul 2010
,
|
![]() |
I need to do a conditional count on a number of assessments. It needs to be a distinct count over person and date. My raw data looks something like this: Name Date Assessment Type Assessment Time
29 Jun 2010
| 2 comments
,
|
![]() |
I have a pretty complex query that pulls the following "Insured IDs" from a table specified in the coalesce statement. The problem is that there are duplicate records with the exception of two letters in a string. I want to be able to only bring in the record with the "RT" In the string. I realize i might have to use a substring of sorts to accomplish this as well as a subquery? Perhaps an IF statement? This is what the data looks like: 42078 00561070 610000000 06042129 Smith Joe 00561000000000000EE19470123F
12 May 2010
| 5 comments
,
|
![]() |
Business Intelligence Architect Urgent Job Opportunity!
29 Apr 2010
,
|