Numbers multiplying by 5 times when imported

logikalyan

Hi all,

I have an issue which I never had before and hoping someone might help.

I am doing a module to module import within the same model. And when I do that my numbers from source model are multiplying by 5 times in destination model. For example if the source number is 20 then the number becomes 100 in destination model. I have tried below things already.

Recreated the import, recreated the view, checked all line item settings, number formats etc and nothing is working. And these are happening for 3 line items only in the module and others are fine.

Anybody have any suggestions other than these will be much appreciated.

Thanks

Kal

Ashutosh

Can you share import template highlighting that records? Also check the decimal separator while importing.

logikalyan

Hi Ashutosh,

Thanks for coming back quickly. Below are 1. Source line item format and 2. Import definition.

Sources numbers below:

All are getting multiplied by exactly 5.

(20), (6,250.0),(3,150.0)

Thanks

Kal

Ashutosh

Hi Kal,

I am assuming this is because you have inputted the numbers like

6,250.0 . Can you check by putting no like 6250.

Thanks

Ashutosh

AjayM

Hi @logikalyan,
Let's first verify one of the 3 problematic lineitems.

May I know about the dimensionality difference (if any) between source module, source lineitem, and target module? Reason being, one of the cases where the number gets multiplied by 'n' times is, when source module has an additional dimension that got 'n' number of list items, when compared to the dimensionality of source lineitem that you are trying to export into target module.

If the dimensions within source module are different, please try to separate those lineitems (with subsidiary views / different dimensions) into separate module and create dedicated action for them.

Cheers!

logikalyan

Hi Ajay,

Below is how these line items configured in source module. The 'applies to' column for these line items has a subset of list. While destination modules is depersonalised by a parent of source module. Both are part of org structure.

When I run the import no errors but just numbers are multiplied by 5.

Basically source module is depersonalised with child of destination module

Thanks

Kalyan

alexpavel

@logikalyan : By default: Anaplan aggregates whatever all the rows shown in the source saved view based on the target dimensionality.

A possibility is that you have a list with 5 elements in source module that multiplies 1 row that you send from source to target module.

I would create a different module source only with the dimensionality that you need in Target (as @AjayM suggested).

Hope it helps

Alex

Dikshant

@logikalyan - Just to confirm, can you share the csv file that you're trying to load? As Alex mentioned, I suspect the same. Source file must have multiple rows with the same data. Anaplan Aggregated the numbers for the same dimension.

logikalyan

Hi Alex,

Thanks for your response.

I cannot create a new source module as its an input module where users input the data into certain level of source dimension. These numbers are aggregated to top which is what mapped to target module.

Target module takes the summary number from source module using import mapping. Is there any other way to address this issue without creating a new source module which is live input module.

Thanks

Kal

AjayM

Hey @logikalyan ,

@alexpavel and I meant to separate the summary lineitems only for the import purpose, and not any input lineitems from the source module.

1. Separate the O4 level summary lineitems into a different module dimensioned by O4 only
2. Create new action to import these new summary lineitems into the existing target module
3. Add this action to the existing process
4. If you have published these summary lineitems from source module on any UX page, you can refer them into new lineitems in the new module and repeat steps 2 and 3. In this case, please remove the mapping for these lineitems from the existing action.

Please note that your numbers got multiplied because the dimensionality of source module and these summary lineitems is different, with a list of 5 items being an additional dimension to the module.

Cheers!

logikalyan

Hi Ajay

I have created a new module and new import as that module as data source and it works fine.

Thanks ever so much for your suggestion.

Kal