Updating the data in your dataset

You can specify the schedule for data updates for your dataset. This ensures that when new or updated data is available from the data source, your dataset and application are updated.

To update your dataset using a schedule

In Web, navigate to the Intelligent Cube for your dataset.
Right-click the dataset, and choose Schedule. The Schedule dialog box opens for your dataset, showing the tables in your dataset.
In the Data Source column, select the check boxes for the tables to update.
In the Refresh Policy column, choose one of the following options:

To replace all the data in your dataset with updated data from your data source, select Replace existing data. Select this option if your dataset contains a rolling set of data—for example, if your dataset always contains data for the last six months.
To update the existing data in your dataset with any updated data in your data source, select Update existing data. Select this option if the data in your data source is updated regularly, but your dataset requires a specific subset of the data.
To update the existing data and add any new data, select Update existing data and add new data. Select this option if your dataset is updated often, for example, a sales dataset that records new transactions and tracks updates to older transactions as applicable.
To add new data from your data source to your dataset, select Add new data. Data that is already in the dataset is not altered. Select this option if old data is not updated after it is saved to your data source.

For complex updates, or to only update your dataset with a subset of the data in your data source, you can create a refresh filter. For example, you can update the tables in your dataset at different intervals, depending on when the data in your data source is updated.

Click Show Advanced Update Options. The Set Refresh Filter and Alternate Source columns are displayed.
Click Set Refresh Filter. The Select a filter dialog box opens.
Click Add Condition. A new attribute qualification is started, displaying a list of the attributes in your dataset.
In the Based On list, select the attribute to filter by.
Define the qualification by doing one of the following:

To create a qualification based on attribute elements in a list (an attribute element is an individual characteristic of an attribute, such as USA or France for the Country attribute):
1. Under Select, do one of the following:
  - To include data only for elements that you select, click In. For example, you can include data for the Books and Movies categories only.
  - To include data for all elements except those that you select, click Not in. For example, you can include data for all product categories except Books and Movies.
2. Type the names of the attribute elements to select.
To create a qualification based on attribute form values:
1. Under Qualification, select the attribute form to base the qualification on. For example, you can filter based on the attribute element's ID form, one of its description forms, or the DATE form if the attribute is time-based.
2. From the list of operators to the right, select a comparison operator, such as Greater Than or Less Than. Do one of the following:
  - To compare the attribute form to a specific value, type the value in the field.
  - To compare the attribute form to another attribute form, select the attribute that contains the second form. Select the second attribute form from the list.
Click the Apply icon to create the qualification. The qualification is created and displayed in the Select a filter dialog box.
Click Save.

If the updated data for your tables is in a different data source than the original, you can configure a different data source for each table. Ensure that the table in the new data source contains columns with identical names to the columns in your original data source. If you do not need to specify a difference source, click Finish.
If the Set Refresh Filter and Alternate Source columns are not displayed on the Schedule dialog box, click Show Advanced Update Options.
In the Alternate Source column for the table to update, click Set Source. The Select Alternate Source dialog box opens.
From the Database Sources panel on the left, select the database connection that contains the data to import. A list of the database tables in the selected database is displayed in the Available Tables panel.
Type the name of the table in the search field. The list of tables is updated automatically as you type.
Click and drag the name of the table from the Available Tables panel to the panel on the right.
Click Finish.