Skip to Content

Condition on timeStamp KeyFigure

Hello All,

I have a requirement to build a report showing top 3 orders whose Inspection Lot is done.

Data is coming from flat file as well as LO cockpit datasource 2LIS_05_QVUDN.

I have concatenated Date and Time field to get time stamp.

Time Stamp is a Characteristic InfoObject. To apply a condition on TimeStamp I have converted it into KeyFigure Info Object (using formula variable)

With all this I am getting output as :

As it can be seen PM Order Time Stamp Values is not as expected and also the not getting the desired Work Orders.

Thanks

prob.jpg (66.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Apr 16, 2012 at 05:37 AM

    Hi,

    The timestamp in the KF is consistently showing one hour less than than the characteristic KF. This is probably due to the the time zone of the user ID running the report. Go to the user profile and check the time zone - I suspect its BST or CET. If so, changing it to UTC should give the correct values.

    About the other point about the wrong work orders showing up, can you please elaborate?

    Regards,

    Suhas

    Add a comment
    10|10000 characters needed characters exceeded