Extracting Work Order Statuses

[Former Member]

Hi there,

I am using JEST and JCDS to extract historical data for Work Order statuses. The extractor is setup to bring the data in as a row model (new record for every status change) but in BW I would want to set this up in the cube or dso as key figure model. Example - the extractor brings in 'Schedule' and 'Released' as 2 different records for a particular work order. I would like for this information be stored in the cube as such that the cube contains 'Schedule date' and 'Released date' as key figures so that these can be used to calculate the difference between the dates of various statuses. In this case, I am trying to find out the difference of days between 'Schedule' and 'Released' status. Is this the right approach to follow for such a scenario? Please share your thoughts or opinions on the subject. Great if you can highlight any pitfalls of taking this approach vs an alternative approach.

Many thanks in advance!!

[shahidimam_shaik]

Hi Intel,

Its not going to work, as in Bex you will try to calculate the date difference in the query. It will give you wrong values. It happened to me. I would suggest you to keep dates as charecters, and use customer exit variables. You can even make use of Offset concept, depending upon your scenario.

Best regards,

Shahid.