LI PY Country and Product Family Sales

Options

Hi, 

I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a dim error when conducting the following formula below. Please assist. 

 

Formula: 'DAT02 PY Revenue to CY'.PY Revenue to CY{LOOKUP:'SYS03 Account>Product Details'.'G2 Country', LOOKUP:'SYS03 Account>Product Details'.'P1 Product Family']

neg177_0-1647890815010.png

 

 

Thank you 

Best Answer

  • TimWard70
    Answer ✓
    Options

    The error will be being driven by the dimensionality of the DAT02 module.  Are G2 Country and P1 Product Family dimensions of DAT02 - i.e. in the applies to?  If not then your dimensionality isn't quite right yet.

Answers