Each attendee learns the components of an OLAP-ready RDBMS application. Using a broad brush, this session discusses the OLAP-ready relational models, analytically enabled SQL, relational OLAP performance and object-based API utilized by BIBeans. Then, it looks at how one can achieve the goal of “everything in 4GL that can be done declaratively can be manufactured in SQL statements.” Samples of windowing functions, ranking functions, lag/lead functions and reporting functions are shown, along with Java class libraries, dimensional cursors, SQL generation and complex calculations. The end result is to show the framework for how one can achieve an integrated OLAP application using the new features supported in 9i and related technologies.