finding difference between date/time

[Former Member]

Hi All,

I am trying to find the difference between sales order create date and actual goods issue date .I have this information coming from 2 different DSO i.e. Sales Item and Delivery.Also these dates do not have the time stamp with them and I need to use additionally one more infoobject called 0crea_time to get the time stamp information.

I have decided to build one more DSO on top of these 2 and then find the difference between dates. Is this possible?Can I access both the DSO's from one of the transformation rules[as I need 2 transformation rules for populating this new DSO, one for delivery and other for Sales Item] for finding the difference between the dates?

Appreciate any inputs on this.

Thanks

Pradeep

Message was edited by:

Pradeep bm

[Former Member · Accepted solution]

don't understand why you need the timestamp for. I would recommed you creating a second dso and store the agi date in the cube do the difference at report runtime

Thanks

Wond

[Former Member]

Hi Pradeep,

Don't create another DSO or Cube. You can get date difference in Bex by following step.

1. Create Infosat using both DSO.

2. Create two formula variable for1 & for2 using replacement path & reference char sales order date & actual goods issue date and select dimensions date.

3. Create CKF and write difference for1 & for2 and unchecked on calculation after aggregation.

Anuj Chaudhary

[Former Member]

Hi Pradeep,

Its possible. But why you want timestamp..? finding date difference or time difference aswell..? for time difference need date and time for creation date and goods issue date.

For only date difference, its better to do at query level. instead of extra DSO and extra processing.

Hope it helps

Srini

[Former Member]

Hi Srivinas,

Yes , there is a requirement for Time stamp as we are displaying in the report a less than 24 hours column for which we need time stamp.

Now how should I proceed as I need time difference also

Thanks

Pradeep

.

[Former Member]

Hi Pradeep,

Try this:

1. Create new DSO/ODS and load both dates(creation and GI) and times(creation and GI).

2. push data from this new DSO to cube. on the way to CUBE calculate date and time difference.(check function modules for date and time diff..).

Hope it Helps

Srini

[Former Member]

Hi Srini,

Thanks again for the reply but I do not have the luxury of creating one more cube on top of this DSO and I need to find the date/time diff while creating the DSO itslef.

How do I do find time diff as I now have 2 transformation rules for building this new DSO i.e. one Transformation rule for populating Sales Order Date and time from Sales Item DSO and another transformation rule for populating Goods issue date and time from Delievery DSO.

Thanks

Pradeep

Message was edited by:

Pradeep bm

[Former Member]

Pradeep,

If you cant go for one more target(ODS/CUBE) and on top this perticular ods, then do loopback.

Load from this new ods to same ods again(loop back). in update rules map only date and time difference fiels and write simple routine to populate.

Hope it Helps

Srini

[Former Member]

Hi Srini,

Thanks , getting closer to solution.Will checkthis out and get back to you.

Thanks again for your time.

Regards

Pradeep