Creating a scripted calculation view

The creation of a scripted calculation view is done in exactly the same way as a graphical calculation view:

1. Open the Modeler perspective of the Studio (see the previous chapter for detailed instructions on how to do this).

2. Open the Quick Launch panel.

3. Select Calculation View | Create. You will be presented with the New Calculation View dialog we saw for the first time in the previous chapter.

4. Enter a Name and Description values (we'll use BOOK_CV_SC, for Book, Calculation View, Script for both Name and Description).

5. Select our book package.

6. Set the View Type option to SQL Script, as we can see in the following screenshot:

   

   Setting the View Type option to SQL Script changes the options available at the bottom of the dialog. We now have the following options available to us:

   • Default Schema: This option lets us define the database schema holding the tables that contain the data with which we want to work. In our case, this database schema is BOOK.

   • Run With: Like...