Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ BI Gateway

viewTddQueue

  • Last UpdatedJun 09, 2023
  • 1 minute read

When a Time-Defining Dimension has been updated, the dimension subsequently requests any of its associated measures to be updated for the same time-range. This view returns a record-set of any pending requests. Once the Runtime receives the request and starts updating its time-slices, the status changes to "Processing". After the measure has completed its update, the request is removed and is no longer included in this data-set.

Column

Description

TDD Queue-Id

The auto-generated Queue ID

(Target) Measure

The name of the DataItem Measure which is targeted to be updated

(Target) Measure DataItem Guid

The Guid of the DataItem Measure which is targeted to be updated

(Source) Dimension

The name of the DataItem Dimension which is the TDD source that requested the Measure update.

(Source) Dimension DataItem Guid

The Guid of the DataItem Dimension which is the TDD source that requested the Measure update.

TDD Start-time (UTC)

The earliest calculated start date and time of the update to the target

TDD End-time (UTC)

The earliest calculated end date and time of the update to the target

Processing Status

The current status (Pending, Processing)

TDD Queue TimeStamp

The date and time when the TDD measure update was requested

Example:

Select * from [dbo].[viewTddQueue]

Related Links
TitleResults for “How to create a CRG?”Also Available in