Numbers multiplying by 5 times when imported

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

Accepted answers

All comments

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.

Separate the O4 level summary lineitems into a different module dimensioned by O4 only
Create new action to import these new summary lineitems into the existing target module
Add this action to the existing process
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

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…