Skip to Content
avatar image
Former Member

Copying a KF value on to another KF, On a conditional basis

Hello Team,

How to Copy one KF value on to Other based on a condition like

- Copy only current to next 2 week time buckets or

- Copy one location demand values on to all other locations.

Does Copy planning operators work here ?

Where to specify these conditions?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 22, 2017 at 01:01 PM

    Hi Venkat,

    It is not possible to copy data from one key figure to another with conditional basis.

    - Copy only current to next 2 week time buckets: PERIOD_OFFSET, DURATION you can manage how many periods data should copy

    - Copy one location demand values on to all other locations: one location demand can not copied to all locations, but you can restrict with attributes which attribute value should copy. Eg:<Attribute>_VALUEn

    Best Regards,

    Lingaiah

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Venkat,

      Duration: This is number of periods which you want to copy data. Eg 104 periods (Weeks)

      Period Offset: This is offset of periods either previous or future periods, data should be copy. Eg If you maintain '0" 104 periods data will copy, If you maintain "-20" previous 20 periods data will copy, If you maintain "20" future 20 periods data will copy.

      So period offset is to data copy restriction, duration is number of periods or time horizon when period offset in involved.

      Constrains for source and target key figures is both key figures are in same base planning level. Source or Target one key figure should be stored.

      Best Regards,

      Lingaiah