Skip to Content
avatar image
Former Member

How to refer to a fixed time period for KF calculations

Hi,

Whats the best method to refer to a fixed time period in a KF calculation. For example:

KF1: qty stored in Oct 2016 bucket.

KF2 calculation requires to refer to this specific time period value only.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Feb 07 at 07:09 PM

    Hello Pravin,

    Can you please explain what you're trying to achieve?

    I don't think it's possible to define a fixed time period in a Key Figure calculation. According to our Model Configuration Guide - Using Time Periods in Key Figure Calculations, we have only 2 ways to define periods in a KF calculation:

    • $$PERIODIDCUn$$: Fixed variable for the current period.
    • PERIODIDn: Time period attribute

    Best regards,
    Matheus

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 12 at 11:28 AM

    Thanks Matheus,

    What we are trying is to have a KF2 populated with values from KF1 where the target time buckets are different at product level. Each product has a different start and end month and values need to be copied from a KF1 to target KF2 to those dates which are product specific. KF1 has values in historical time buckets which are different than the target time buckets where these values need to go and sit. These start and end dates can be made available for each product within additional attributes of the product.

    Could the Copy Operator work with different product level offsets?

    Thanks!

    Pravin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 13 at 01:00 AM

    HI Pravin,

    You can try HCI to extract the data for Product Dates and KF values and based on your required logic transform the data and update it in IBP.

    Thanks,
    Chandra

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 02 at 09:42 PM

    Hi Praveen

    Can you send mock-up example in excel?

    Regards

    Ankur

    Add comment
    10|10000 characters needed characters exceeded