This article explains how snapshots function in the OneAnalytics integration.
OData Table Names
Snapshots currently can be done for all tables listed in the following table. All tables that are listed within this field will be queued up to be snapshot regardless of the other two fields below.
|
Activities |
Plan_Epic |
Plan_Project |
ResPlanLog |
|
Assignments |
Plan_Idea |
PlanDependency |
StatusReports |
|
Association |
Plan_KeyResult |
PlanInsights |
Tasks |
|
Costs |
Plan_Objective |
Plans |
TimeOff |
|
ModelerModel |
Plan_Portfolio |
RateTable |
TimesheetAudit |
|
ModelerScenarioPlan |
Plan_Program |
Resources |
Note
Snapshots currently can be done for all tables listed above except for Capacity, ResPlan, Timesheets, and Teams. All tables that are listed within this field will be queued up to be snapshot regardless of the other two fields below.
Columns to Snapshot
To guarantee the accurate selection of columns for snapshotting, the value entered here should adhere to the TableName{Field} format. This elaboration builds on the list of tables specified in the OData Table Names field and zeroes in on the specific fields intended for snapshotting.
What happens if no values are entered?
In the event that no values are entered in this field, the default behavior will result in the snapshotting of all columns within the OData Table names field.
What happens when values are entered?
When the values of TableName{Field1,Field2} are entered within the Columns to Snapshot field, those specific tables will be queried for the snapshot. Once the TakeOnePlanSnapshot strategy has run, a new table will be created within SQL with the name of OnePlan_Snapshot_{TableName}.
Choice Column for Time Tracking
What happens when values are entered?
When choice fields are listed, a new Snapshot table will be generated for any table that has the choice field listed, regardless of the table that has the choice value.