Import Revenue FY19 into DAT02 PY Revenue to CY

Highlighted
Contributor

Import Revenue FY19 into DAT02 PY Revenue to CY

Hi community, 

 

I need some hints to be able to move forward in the training because I don't know if I am proposing the solution in the correct way. The point is that on the following exercise:

 

4.6.5 Sale Planning Model: DAT02 module

In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters

 

what I am doing is trying to import data from the Data Hub from module DAT05 Historic Revenue by Product (with dimensions A1 Account, P2 Product) into DAT02 PY Revenue to CY (with dimension A2 Account>Product#) into FY19 and after that, I will apply formula to carry into FY20. But I am struggle into import the data from Data Hub as source module has dimension A1 Account, P2 Product and target module has dimension A2 Account>Product#. Any hint on this? 

 

Thanks in advance

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Import Revenue FY19 into DAT02 PY Revenue to CY

@jagalindo 

 

Is there any specific reason that you are dimensioning your target module with Account>Product# list? As far as I know you have to use Account, Product lists as dimensions so that your import goes smooth. After that you can create separate module which will be dimensioned by combined list and tackle that with formula.

 

Hope that gives you enough to proceed

Misbah

Highlighted
Contributor

Re: Import Revenue FY19 into DAT02 PY Revenue to CY

Thanks @Misbah for your hint. 

 

I just applied dimension A2 Account>Product# because the print screen on the next section of the training material to compare the DAT02 Model seems to be that dimension, as you can see according to the print-screen on the training material:

 

2020-09-11 DAT02 PY Revenue to CY.png

But agree with you that with dimensions A1 Account, P2 Product is better to import and then I can create other module with combined lists. 

Thanks for your support. 

Jose.