Level 2 Sprint 2 DEM03 Growth Rate % line Item

Options
Joh04924
Joh04924
in Modeling

 

For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:

Screen Shot 2020-06-30 at 4.41.32 PM.png

The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.

I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.

Tagged:

Answers

  • AashcaJ
    AashcaJ
    Options

    @Joh04924 I would say you are on the right path with "LOOKUP". Look at the mapping reference again, follow that exact sequence and check your logic.

     

    DEM02 --> SYS08 --->DEM03

  • Joh04924
    Joh04924
    Options

    Thank you! 

  • Kanishq17
    Kanishq17
    Options

    hi @Joh04924

    You need to check the dimensions at source and target when using LOOKUP, so you see in source there is P1 and in target there is P3, so need a mapping between P3 and P1, so in the SYS module we get the P1 prod family for P3 SKU using PArent(parent()) , now based on the mapping, you can lookup values from dem02, so it will be dem02.lineitem[lookup:SYS08.Prod family]

     

  • Tricia
    Tricia
    Options

    @Joh04924  - were you able to resolve this? I am having the same issue.

     

    Thanks!

  • neg177
    neg177
    Options

    Hi,

     

    Were you ever able to figure out the Formula for the growth rate line item in Moduel DEM03?

  • augustus.perera
    augustus.perera
    Options

    Hi

     

    Please, need some help , I am passing the same passage.

     

    IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DEM01 Volume Growth Rates'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] ELSE 0

     

    Context: Growth Rate Module P1 , DEM 3 Module has P3 and both P1,P3 are in SYS08

    Augustus_0-1601110308965.pngAugustus_1-1601110345104.png

    Augustus_2-1601110476361.png

    it brings no value.

    Augustus_3-1601110591693.pngAugustus_4-1601110602183.png

     

     

  • augustus.perera
    augustus.perera
    Options

    Augustus_0-1601110760812.png refer weekly % module

  • augustus.perera
    augustus.perera
    Options

    Hi appreciate some guidance ..both formulas don't bring any values

     

    Augustus_0-1601111384804.png

    Augustus_1-1601111538807.png

    the DEM1 Module view

    Augustus_2-1601111600672.png

     

     

  • jjayavalli
    jjayavalli
    Options

     dem02.lineitem[lookup:SYS08.Prod family] it gives an error message, formula invalid.

    Not sure what am I missing this time.

     

  • SRoberts
    SRoberts
    Options

    Looks like everyone has figured the correct SYS08 Product Family Lookup for this line, but recall that in a prior step we created DEM02 Volume Growth Rates by Week using formula 'MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)' to bring the monthly value in DEM01 down to a weekly level.

     

    My formula was successful when I accessed that weekly growth rate data.

  • jjayavalli
    jjayavalli
    Options

    Hi, so are you suggesting to divide the MONTHVALUE/ 4 to get the weekly Growth %? I have used the Lookup Function here instead.

    so wondering. Thank you:) 

  • mebby2k
    mebby2k
    Options

    'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]

  • Evahong
    Evahong
    Options

    I have this problem too. Anaplan shows level mismatch on common dimension (attached screenshot). Are we missing on another dimension?

Categories