Notifications (Storage Options Dialog Box) (Analysis Services - Multidimensional Data)
Use the Notifications tab of the Storage Options dialog box in Business Intelligence Development Studio to set the notification method and related settings for a dimension, cube, measure group, or partition.
Note
You should be familiar with storage mode and proactive caching functionality before modifying these settings. For more information, see Proactive Caching (Partitions).
Options
Term |
Definition |
|---|---|
Storage mode |
Selects the storage mode to use for the object.
|
Enable proactive caching |
Enables proactive caching. .gif "Note") Note
If this option is not selected, all options except Storage mode are disabled.
|
SQL Server |
Uses a specialized trace mechanism on Microsoft SQL Server to identify changes to underlying tables for the object. |
Specify tracking tables |
Specify the underlying tables to be tracked for the object, then type a list of tables delimited by semi-colon (;) characters or click the ellipsis button (...) to open the Relational Objects dialog box and choose the tables to be tracked. For more information, see Relational Objects Dialog Box (Analysis Services - Multidimensional Data). If this option is not selected, Analysis Services tries to determine the list of underlying tables to be tracked for the object, if certain requirements are met. For more information about these requirements, see Proactive Caching (Partitions). |
Client initiated |
Select to use the XML for Analysis (XMLA) command, NotifyTableChange, to identify changes to underlying tables for the object. This option is typically selected if you plan to use a client-based notification process. |
Specify tracking tables |
Select to specify the underlying tables to be tracked for the object, then type a list of tables delimited by semi-colon (;) characters or click the ellipsis button (...) to open the Relational Objects dialog box and choose the tables to be tracked. For more information, see Relational Objects Dialog Box (Analysis Services - Multidimensional Data). If this option is not selected, Analysis Services tries to determine the list of underlying tables to be tracked for the object, if certain requirements are met. For more information about these requirements, see Proactive Caching (Partitions). |
Scheduled polling |
Uses a polling mechanism to identify changes by running a series of queries on the underlying tables for the object. |
Polling interval |
Specifies the interval and units of time for the period that should pass before Analysis Services executes the polling queries and processing queries defined in the polling grid. |
Enable incremental updates |
Incrementally updates the MOLAP cache for an object based on a set of polling and processing queries designed to identify only additional data. If this option is selected, the polling query is associated with a table identifier in the data source view. The processing query is then used to compare the current value of the polling query with the stored value of the previously executed polling query to identify changes. If this option is not selected, the MOLAP cache is fully updated. The polling query is used to identify that a change has occurred, and no processing query or table identifier is required. |
Polling grid |
Contains the polling queries, processing queries, and table identifiers used by Analysis Services to poll the data source and identify changes to underlying tables for the object. The grid contains the columns listed in the following table.
ColumnDescription
Polling queryType the singleton query executed at the polling interval to identify changes for the object, or click the ellipsis button (...) to open the Create Polling Query dialog box and define the singleton query. For more information, see Create Polling Query Dialog Box (Analysis Services - Multidimensional Data). If Enable incremental updates is selected, the polling query should return a value that identifies the last record added to the table identified in Table. If Enable incremental updates is not selected, the polling query should return a value that identifies the current number of records in the table.
Processing query
Type the query executed at the polling interval to retrieve new records from the table identified in Table, or click the ellipsis button (...) to open the Create Processing Query dialog box and define the query. For more information, see Create Processing Query Dialog Box (Analysis Services - Multidimensional Data).The query should be parameterized to accept two parameters—the previous value returned by the query in Polling query and the current value returned by the query in Polling query—that can be used to identify and extract only the records that have been added during the polling period.
Note
This option is enabled only if Enable incremental updates is selected.
TableType the identifier of the table against which the query in Polling query tracks the last record, or click the ellipsis button (...) to open the Find Table dialog box and select the table. For more information, see Find Table Dialog Box (Analysis Services - Multidimensional Data).
|