Inconsistency on importing data from module to module

Hi All,

Does anyone encountered this scenario on importing from the same module. I'm trying to import the value of Aug 20 - Actual to Sep 20 - Budget using a saved view.

Here's the result:

Item B to F imported the Aug 20 value. But item A seems to add .04.

I also tried to zero out Aug 20 then run the import again and here's the result.

Hope someone can help on this.

Thank you!

Jud

Accepted answers

AlejandroGomez

thanks for the additional details, @JLD

First a quick double-check on the source Line Item: does the line item "Copy Rule Driver: Input" returns the right value for the Line Item "A" in September and Budget? I mean, does that line item return 1 or 1.04 for the data point Budget, September, Line Item A? Lets make sure that the error is not occurring before the data load process:

Then, if you are loading data from August to September: shouldn't the Time column display "September" instead of "August"? AS per yur screenshots looks like you are loading August data into August and September into September and so on. Seems to me that the "Time" field should be September and then the Line Item "Copy Rule Driver: Input" should retrieve the value from August bu using Lookup by chosen Month and Version, so for your time "Sep" the line item "Copy Rule Driver: Input" would retrieve the value from Aug and Actual to be loaded into September and Budget.

I hope the two suggestions above helps you to debug the process.

Cheers

Alex.

All comments

anirudh

Hi JLD,

Can you zero out August again and then edit the import action that you're using to update the module and share a screenshot. I'm looking for the window that shows the source data when you edit an action..

Regards,
Anirudh

AlejandroGomez

Hi @JLD

I agree with @anirudh: some more details would be necessary. It would be great to have a screenshot of the saved view being used as source and of the mapping settings, specially the ones for Time and Versions, since I suspect that the issue could be there most likely.

I do not know how you are mapping Aug to Sep, but If you are using a Line Item for calculating the next month for each month, it could be that that particular line items is retrieving Sep20 twice somewhere in the model?

Looking forward to get some more details so we can find where is that .04 coming from!

Cheers,

Alex

JLD

Thanks @AlejandroGomez and @anirudh for the response.

Here are more details of the importing.

1) I have a parameter here which tells what month and version to copy from and to.

2) This is the saved view used in the import filter by selected version and month.

3) Import definitions

Thanks.

AlejandroGomez

thanks for the additional details, @JLD

I hope the two suggestions above helps you to debug the process.

Cheers

Alex.

JLD

Hi Alex,
Thank you so much for your help! I was able to review the import definition.

AlejandroGomez

I am happy it helped! 🙂

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?