9 Replies Latest reply: Jul 5, 2010 6:02 AM by MondayBI RSS

    Datacopy problem Business rules

    738966
      Hi Experts,

      I am having some problems in trying to get the following business rule to work.

      FIX("CUSTOMER_NA","INDUSTRY_NA","VENDOR_NA",[Version],[Year],@Relative("Area",0),@Relative("VALUE TOTAL",0))
      FIX(@Relative("Account2",0),@Relative("Account1",0))

      datacopy [Periods]->"ACT"->"Department_total" to [Periods]->"FCST"->"Department_NA";

      ENDFIX
      ENDFIX

      It is not copying any data at all.

      However if I rewrite the equation to the following, I am able to copy the data.

      datacopy [Periods]->"ACT" to [Periods]->"FCST";

      Obviously I am required to copy the data from department total to department_na... could it be related to some of the dynamic calc or 2 pass calc settings?

      Many Thanks and Regards

      Andrew