LOOKUP not working to change dimensionality of a line item

Options
LucaRicci
LucaRicci
in Modeling

Hello,

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

  • company, gr consolidation, scenario, year

image.png
image.png

to:

  • company, gr consolidation, scenario

in line item layer yearly pt.2

image.png

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

image.png

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

image.png

How can I fix this issue?

Tagged:

Answers

  • Dikshant
    Dikshant
    edited June 7
    Options

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

    image.png
    image.png
    image.png

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

Categories