Using the AT and FOR Options with Relational Summary Functions

How to use the AT and FOR to control the aggregate behavior of relational summary functions. These allow the scope/grouping (regular aggregates) and the level of pre-aggregation to be set (running aggregates). A crosstab running-total example is supplied.

01 January 2009

This document outlines the use of the AT clause in summary functions. An example is also provided with step by step instructions on how to create a cross tab report that displays the totals and running-total for a given measure.

In this article

Topics covered include:

  • INTRODUCTION
  • THE FOR CLAUSE
  • THE AT CLAUSE
  • DISPLAYING A RUNNING-TOTAL IN A CROSSTAB
  • CONCLUSION

Download

DescriptionNameSize
Article in PDF formatusing_the_at_and_for_options_with_relational_summary_functions.pdf192KB

Resources

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Business analytics, Information Management
ArticleID=360642
SummaryTitle=Using the AT and FOR Options with Relational Summary Functions
publish-date=01012009