I have a AS server which has 10 Cubes. For one of the dimension proactive caching is enabled and below is the Polling Query and it is not enable for incremental updates and Polling interval is 30 seconds. Silence interval and silence override interval are 0 seconds
DECLARE @TABLE_NAME VARCHAR(200)
SET @TABLE_NAME = 'XYZ'
SELECT Isnull(Max(last_user_update), '2000-01-01') last_user_update
FROM sys.dm_db_index_usage_stats i
JOIN sys.tables t
ON ( t.object_id = i.object_id )
WHERE database_id = Db_id()
AND t.name = @TABLE_NAME
When I Update XYZ table data some time data wont be updated in OLAP Cube at all we need to process the dimension manually to get updated data.
Can anyone help/suggest on this issue. Thanks in advance.