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 ...