4 Replies Latest reply: May 23, 2018 12:22 PM by David Forest RSS

    Limiting Data in Load Editor Script

    Sarah Kelly

      I would like to eliminate older charge data however, I need to still include older charges if their owed amount is not $0.

       

      I came up with the where clause

       

      Where not (((year(today(0))*12)+month(today(0))) - (((year(“Date of Service”)*12)+month(“Date of Service”))) > 25

      And “Owed Amount” = 0)

       

      My problem is that the field "Date of Service" is in the Charge_Dimension section of the data load editor and "Owed amount" is in the Master_Fact section of the data load editor so I am unsure where/how to include this where clause in the load script.

       

      I can’t just write where not year(today(0))*12)+month(today(0))) - (((year(“Date of Service”)*12)+month(“Date of Service”))) > 25 in the Charge_Dimension section and Where not “Owed Amount = 0” in the Master_Fact section because this will give me entirely wrong results, it has to be a combination of the two parameters.


      Any thoughts?