10
Working with Relational Tables

In this chapter, you will learn how to write OLAP DML programs that use the OLAP DML SQL command. With these programs, you can update relational tables and copy data between relational tables and analytic workspace objects.

This chapter includes the following topics:

• Issuing SQL Statements Through the OLAP DML
• Creating an Analytic Workspace from Relational Tables
• Example: Creating an Analytic Workspace from Sales History Tables
• Writing Data from Analytic Workspace Objects into Relational Tables
• Using Stored Procedures and Triggers
• Checking for Errors