You can configure workbook settings when you create a new workbook and you can edit them as needed, later. The system administrator can also edit the workbook settings.

Configuring Workbook Settings

On the Workbook Settings page, you can configure the following options.

Trigger options

The trigger settings specify how often the workbook data is calculated. It has the following options: 

Data driven options

For example, this workbook recalculates when the data source 1 or 2 update in Datameer unless Data_Source_1 has updated less than 2 days from today or Data_Source_2 has updated within the past 3 hours. The workbook doesn't run if Data_Source_3 updates.

Scheduled options

For example, 0 9-15 * * * indicates that the task should launch once every hour between 9am to 3pm everyday.

Data retention

Options on how to store workbook data. 

Purge historical data

Setting to delete previous results so as to free available resources. 

Never delete historical data

Any time a workbook runs, the previous data is stored until manually discarded.

Export only

This option is available for those that don't want to keep workbook calculations on HDFS. All data is deleted and is only able to be accessed from where it was exported.

Description

Option to give a description for your workbook.

Saving results and time based partitions

Saving results specifies which workbook sheets are saved and visible. By saving only the sheets that you need you can improve performance and computation time. If you want to retain smart sampling on filtered sheets, make sure to save them. Smart sampling is disabled if a sheet isn’t saved because it can slow down other processes. 

The Time Based Partition column displays which sheets have a date type column. If not all partitions need to be saved, set specific date ranges to save.

Error handling

Specifies what to do if Datameer encounters a row that possibly contains invalid or missing data.

You can choose to:

Notifications

You can also specify who should be informed if there is a problem or when a workbook is successfully run. Separate multiple email addresses with a comma.

Advanced workbook settings

The advanced settings allow custom key/value properties and logging severity/customization options.

Run workbook after saving or updating the workbook

Select the checkbox to run the workbook directly after saving or updating the workbook configuration page.


Changing Workbook Settings

To change workbook settings:

  1. Select the workbook from the File Browser.
  2. Click the Configure from the Edit menu or right-click and select Configure.
     
  3. Make changes and click Save.