Hi ALL,
In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level.
I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group =
'FIND D3 RS Group'[LOOKUP: 'Attributes D3 RS Group'.FIND Role]) is dimensioned by G5 Location × D3 RS Group. When I try to use this line item in a LOOKUP to pull the Need from the D3-level module, I get a dimensionality mismatch error.
My goal is to restructure this so that I can then use this result to LOOKUP the Need at the G5 Location level.
Any suggestions pls!