Share
Report
59Hello 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
Categories:
All responses (
Answers (
