O'Reilly logo

Oracle Business Intelligence Discoverer 11g Handbook by Michael Armstrong-Smith, Darlene Armstrong-Smith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
21
Analytic Functions
In this chapter we will introduce you to Oracle’s analytic functions and show you how to use these powerful objects. We will discuss some essential concepts and show you how to use a template to help you create the functions. After this, we will show you some practical examples of using analytic functions. Following the practical examples, we will explain how you can use Boolean logic to sequence conditions in such a way as to force Discoverer to apply a condition based on an analytic function first. Next, we will discuss the two types of windowing options: explicit and dynamic. Finally, we will talk a little about ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required