Level 3 Sprint 1 User Story 1.3 DAT02 PY Revenue to CY
Please advise what am I doing wrong.
I imported PY Revenue data from Data Hub Model to Sales Planning Model.
Source - DAT05 Historic Revenue by Product,
Applies To: Accounts Flat (150 members), Products Flat (53 members),
Time scale: Quarter, Time range: FY19
Line item: Revenue
Cell count: 31,800 = 1 x 150 x 53 x 4 (Quarters)
Summary methods: None, None
Target - DAT01 Revenue PY with the same structure absolutely.
While mapping I see the screen below with an empty FY19 column. OK, I have no data for FY19 in the source file, but why does it appear if I set the summary for the target as None, None?
After running the import I get a message below. Failed 7,950 = 150 accounts x 53 products, I guess, for the total FY.
Another concern is the different timescales of Data Hub (weekly) and Sales Planning (monthly) models. Does it have any impact?