LOOKUP not working to change dimensionality of a line item



I am trying to change the dimensionality of the line item "layer yearly pt1" from:

  • company, gr consolidation, scenario, year


  • company, gr consolidation, scenario

in line item layer yearly pt.2

My attempt was to lookup "layer yearly pt1" using a year to scenario mapping as in "WKK17 year to scenario mapping":

However that does not seem to be working, in fact:

How can I fix this issue?



  • Dikshant
    edited June 7

    do you want to lookup FY24 data in Layer Yearly pt2 line item? If yes, check this.

    Since you have scenario dimension already in Layer Yearly pt2 line item you don't need a year to Scenario mapping.