Page Comparison

PNE-1877

https://slxdev.atlassian.net/browse/PNE-1877

Create Paging tables with the following data points from whatever we have in PNE databases.Use the federator postgres connection.

Dim Page

Page Id (NOT hidden)

Title (first “text” node)
Machine_id (hidden, joins to Dim Machines)
IsResolved
IsCancelled

Created By

Department

Fact Page Status

Page Id (hidden)

Status (open,WIP,Resolved,Cancelled)

Start DateTime
End DateTime
Duration (resolved or cancelled durations (last status) is always 0. “terminal step”.)
User (accepted_by)

Joins:

• Dim Page joins to Dim Machine, single linear path.

• Dim Page cannot join to shifts without sisense help → join paths will get very confused and we cant use the “buster” technique because shortest path is not respected (bug?).