Pivoting, Retaining, and Suppressing Data

After you retrieve data into the worksheet, you can manipulate the data in various ways. For example, you can move rows and columns to various positions in the worksheet, or you can tell Essbase to suppress or to retain data during data retrievals.

To help you manipulate worksheet data, this section steps you through these procedures:

Make sure you are connected to the Sample Basic database. If you are not connected, follow the steps in Lesson: Connecting to a Database.