SYS14 Automatic sum over Flat List not possible
The line item "Data?" in Data Hub Model: SYS14 module was asked to reference SYS12 SKU Details and SYS13 Account SKU filter which were created during Level 2 Data Hub. However, both SYS12 and SYS13 were using SKU Flat as dimensions (as instructed in Level 2 training). When trying to reference the two modules, I got error indication "Invalid formula for 'SYS14 Create Account>Product'.Data?: Automatic sum of 'SYS13 Account SKU Filter'.Has Data? over SKU Flat hierarchy is not possible as SKU Flat does not have a built-in top level".
Shall I assign parents and top levels for the SKU flat list? or change SKU12 & SKU13 dimensions from "SKU Flat" to "P3 SKU"? I know the problem is not from the formula but from the list structure.