This is not a dimensionality problem. Both modules has 'A2 Account>Product#' list, 'Time' list and 'Line Items' list. I use LOOKUP to obtain information from Account level, but results is incorrect. There is no information about 'PY Account Revenue' in User story and Model Build Specifications. Also there is no data checks for 'PY Account Revenue'. As I understand 'PY Account Revenue' is sum of 'PY Actual Revenue' for specific account in 'DAT02 PY Revenue to CY' module.
... View more