Formula error while pulling data from one module to another

[ankulkarni]

Hello, 

My goal is to get the 'total volume' of product being used for certain year by different cities. 

Below are the two data set which have been successfully mapped into Anaplan

I want to pull data from DATA02 into REV02 to achieve my goal. 

SOURCE

 DATA02- (data SKU Volumes) 

 

TARGET: REV02- (data Volume Inputs)

I tried using LOOKUP function but somehow unable to use it. 

What is the right way to map data so that my goal is achieved?

Thanks

[einas.ibrahim]

Hi @ankulkarni 

I guess when you say "successfully mapped into Anaplan", by mapped you mean imported. Mapping means something else.

Generally, when we want to  reference a line item from a source module into a target module (where the data should end), we could have a couple of cases:

1. The dimensions of both modules are the same. In this case a direct reference such as Line Item = Sourrce Module. Line item will do the job.
2. The dimensions of the modules are different. In this case, we need to use mapping and a LOOKUP or SU 

Here are the dimensions of the module you mentioned. 

Module REV02 (Target) is dimensioned by: 

1. G3 Location  
2. P2 Product (Parent of P3)
3. Time: Months

Module DAT02 (Source) is dimensioned by:

1. G3 Location 
2. P3 SKU
3. Time: Months

Do you think we need to use direct reference or mapping here?

[fuvasm]

Hi @ankulkarni, 

Your source data is by P3 / G3 / Month while Target is by P2 / G3 / Month. Take note in Anaplan, if you have setup composite hierarchy Lists, data will aggregate automatically and you dont have to use any function. So in your case, P3 will aggregate to P2 (based on parent child relationship), and G3 / Month will map directly.

I notice subsidiary view in your blueprint view snapshot - kindly correct that before you reference source module line item.

Cheers!

[einas.ibrahim]

Hi @fuvasm ,

😊Thank you for your note. I wasn't actually "asking", I was trying to help @ankulkarni arrive at the answer himself. But you are certainly correct.

@ankulkarni even though your line item has the same Time and Version as for the module, and you haven't specified a different dimension for the Line Item, you do have a subsidiary view. Why is that?

If you notice the Line Item's "applies to" you'll see that it is blank; it should have a dash "-" instead to denote that it uses the same List dimensions as the module. It's a subtle issue.