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 can be done for all out of the box oData tables except for Capacity, ResPlan, Timesheets, and Teams.
Columns to Snapshot: To ensure that the proper columns are being snapshotted, the value here must be in Table{Field} format. This is to elaborate further from the list of tables from the OData Table Names field and focuses on specific fields that are desired to be snapshot.
-
What happens if no values are entered?
If no values are entered within this field, all columns within the OData Table Names field will be snapshot.
-
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.
Comments
0 comments
Article is closed for comments.