which table to use to analyze production times ?

(0) Share

Report

Posted on by JeanB

Hello guys,

I need your precious help to define a data cube that will be used for PBI reports.

The need is to know production times for operators, machines,...

The problem is that I don't understand how the JmgStampJournalTrans table works. I was under the impression that it was a consolidation of data from JmgTermReg, but a lot of rows are missing. I understand that to make one line in JmgStampJournalTrans, you need two from JmgTermReg: one for the start of the job and one for the end. But even so, I'm missing a lot of data and I can't figure out why.

Is there a better table to carry out my purpose ? Do I need to make a view based on JmgTermReg to be sure to have all the data ?

Thanks