0 - 25 of 25 tags for olap

I've a data in the following format  -
cust_name , month, isAccountActive
A, jan-15, 1
A, feb-15, 1
A, mar-15, 0
A, apr-15 , 1
A,  may-15, 0
B, jan -15, 0
B, feb-15,1
B, mar-15,1
B, apr-15, 1
My output should look like follows-

Hi All,
I'm getting an error regarding non aggregate values when using sum over partition function. Basically, my goal is to get the total of a measured column for a particular descriptive column. i.e. 



A.Product Type,



Dear All, Need help with below situation....
id        date
100   6/6/2015
100   8/1/2015
100   9/30/2015
200   8/11/2015
300   7/18/2015
300   1/10/2015
300   3/5/2015
300   6/15/2015

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.

This presentation demystifies usage of  OLAP Analytics function for TD 15.0 and previous releases.

So i've been searching all around on how i could increment a column in Teradata. I'm new to this so im not really familiar with all the syntax or tactics that i could use. 
I've read about autogenerated identity column, OLAP and recursive in teradata but i think it does not matches my need. 
So here's my problem.

I'm trying to write an SQL statement based on this example data (just the first 3 columns)
799              01.06.2014   1            
799              02.06.2014   1

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.

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.

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

This webcast describes how you can leverage Essbase and Teradata Database technologies to improve your analytical application environment.

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)

I am trying to calculate moving sums and row counts in a query, to do further arithmetic on the said values. For a range of 3 days, for example, I would sum the values given in the rows for those 3 days, and then divide them by the amount of rows in that same time period.
In Oracle, the syntax would be:

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.

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.
I have used several olap functions to build a table that has the following data:

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.


Following is the data I currently have

 DateTime                User                   Number

I have a table with Columns A, B below but I want to create Column C

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.

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:
create table dev_eis_t.jlee80_agg_test
( id integer not null
, groupid char(1) not null
, selectionid char(1) not null
, qty integer not null
primary index (id)


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

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

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
Chuck Smith 6/7/2010 1 6/7/10 1:00
Chuck Smith 6/7/2010 2 6/7/10 1:00
Chuck Smith 6/7/2010 3 6/7/10 1:00
Chuck Smith 6/8/2010 1 6/8/10 1:00
Chuck Smith 6/8/2010 1 6/8/10 2:00
Chuck Smith 6/8/2010 1 6/8/10 3:00
Chuck Smith 6/8/2010 2 6/8/10 1:00
Chuck Smith 6/8/2010 2 6/8/10 2:00
Chuck Smith 6/9/2010 2 6/9/10 3:00
Chuck Smith 6/9/2010 3 6/9/10 14:00

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

Business Intelligence Architect
Position Type: Full-Time, Permanent
Company Name: HSGI Inc.
Location: Atlanta, GA
Primary Skills: BI, Architect, Data Modeling, Data Analysis, SQL, Data Warehouse, Data Mart, Dashboards

Urgent Job Opportunity!
Only Serious Candidates Need to Apply! We can set up interviews for you immediately!
Please reply with ALL of the following information:
• An updated copy of your resume in a Word (.doc) Document
• Current and expected compensation
• A brief introduction type paragraph outlining your skills and experience relative to the Job Description