More discussions in Business Intelligence Old Forum 1 (Read Only Archive)Where is place located?
    3 Replies Latest reply: Dec 7, 2011 7:52 AM by Murali R RSS

    Ageing Calculation in Bex

    Murali R
    Murali R Dec 6, 2011 5:13 AM
    Currently Being Moderated

    Hi,

     

    I need to calculate the Ageing in a Bex Query based on the Current date & Clearing date.  To calculate Ageing, i am first trying to get the difference between Current date & Clearing Date.  By refering a PDF posted here in SDN for Ageing, i created the Current date as Customer exit & the date value is getting populated for this, i checked this through debugging the Customer exit. 

     

    Whereas, For the Clearing date, i created a Formula Variable with Replacement path assigning Clearing date as the Reference Characteristics.  As per the document for the Replacement Rule, i gave 'Attribute value' as the Replace with.  But for this type, in the Dimension(Last tab in Variable creation screen) 'Date' is not coming up, only Quantity, Amount etc. are coming in.  So, in the output, i am not getting the difference in Numbers, instead its giving up the Current date.

     

    Any help on this will highly be appreciated.

     

    Regards,

    Murali

    • 220 Views
    • Re: Ageing Calculation in Bex
      Anshu Lilhori
      Anshu Lilhori Dec 6, 2011 6:23 AM (in response to Murali R)
      Currently Being Moderated

      Hi,

       

      Please choose replace with key instead of attribute value.And make sure to keep Clearing date in rows.

       

      Hope it helps.

       

      Regards,

      AL

       

      Edited by: AL1112 on Dec 6, 2011 6:22 AM

    • Re: Ageing Calculation in Bex
      Prashanth Konduru
      Prashanth Konduru Dec 6, 2011 6:56 AM (in response to Murali R)
      Currently Being Moderated

      Hi Murali,

       

      In the document you had referd to has the data field as attribute thats why in the document reference it was selected as attribute, in your case it will key not attribute as clearing date is itself a char not a attribute of any IO.

       

      select key and check in the last tab you will find date.

       

      Difference of dates will be numeric value only not the dates.

       

      Documents in SDN are only for reference the procedure may warry depending on the business requirement.

       

      Regards

      KP

    Actions