LI PY Country and Product Family Sales



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']




Thank you 

Best Answer

  • TimWard70
    Answer ✓

    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.