Notifications (Storage Options Dialog Box) (Analysis Services - Multidimensional Data)

Use the Notifications tab of the Storage Options dialog box in SQL Server Data Tools (SSDT) to set the notification method and related settings for a dimension, cube, measure group, or partition.

[!UWAGA]

You should be familiar with storage mode and proactive caching functionality before modifying these settings. For more information, see Storage Options Dialog Box (Analysis Services - Multidimensional Data).

Options

Term	Definition
Storage mode	Selects the storage mode to use for the object. MOLAP The object uses multidimensional OLAP (MOLAP) storage. HOLAP The object uses hybrid OLAP (HOLAP) storage. ROLAP The object uses relational OLAP (ROLAP) storage.
Enable proactive caching	Enables proactive caching. [!UWAGA] 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 (SSAS).
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 (SSAS).
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. Column Description Polling query Type 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. [!UWAGA] This option is enabled only if Enable incremental updates is selected. Table Type 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).

Zobacz także

Odwołanie

Storage Options Dialog Box (Analysis Services - Multidimensional Data)