Formula

@jasonblinn Thanks for your previous answer.

I had one more question.

Here I am use 2 modules, puling data from one modules to another with same line items by directly referring each line item. But I am not getting the values into target modules.

From 1st snapshot I am trying to pull data into 2nd ss.

Can you please help me understand and solve this.

image_97514.png

Accepted answers

All comments

Puneeth H P

Hi @Human008

If the values are not coming up , the reason must be missing dimension from the source to target .

Do we have BLANK values in subsidiary view as well !?

Try to LOOK Up to all the missing dimensions from Source in target .

Thanks,

Puneeth HP

Human008

@Puneeth H P

Hello Puneeth,

I can see data in subsidiary view and tried using Lookup function as well. But I am getting error message saying list and data had relation.

Can you please clear me that.

Thank you.

Puneeth H P

SS of both Dimensions and error message would help here .
Thanks

Human008

@Puneeth H P

Here are the two SS 1st is the source and 2nd is the target.

image_97526.png

ChrisAHeathcote

@Human008

From the screen shots you provided it is not possible to see the dimensions of either the source or target modules.

An error is likely to be a mismatch of dimensions meaning that you need to map any differences in dimensions from the source to the target.

Therefore, list out the dimensions present in your source and those in the target and identify any differences.

Time - is there a change in the time dimensions from year to month, month to day etc?
Hierarchies - is the target set at a higher level in the hierarchy?
Missing dimensions - are there any dimensions that are simply missing in the target that are present in the source or vis versa?
Versions - does one module have versions and the other not?

Use system modules to map across these differences in dimensions. For time you could use MOTHVALUE() or YEARVALUE() or LOOKUP within a time systems module the relative parent. Similarly, with a movement down a hierarchy use a systems module dimensioned by the list present in the target to LOOKUP the parent present in the source.

Where there a simply missing dimensions build dedicated mapping modules containing the list present in the target. Use line items formatted as the target dimension that is missing and map each combination of target dimensions into the source list.

Where there are more dimensions in the source use SUM to aggregate the source data into the corresponding target dimension. Create a module dimensioned by the source lists and use a list formatted line item formatted to the list in which you will SUM the data into.

Good luck,

Chris

Human008

@ChrisAHeathcote @Puneeth H P

Does this ss work ? all the time, hierarchy all are similar don't know why it is not able to pull data from source to Target

and when I am using lookup there is an errort, I am attaching the error as well.

I can't understand this, please help me with this.

Thank you.

Here if it is coming up in subsidiary view and not coming up ,the reason might be of not matching period .
Error we are getting here because we are not matching time dimension properly here . LOOKUP always works on list or time formatted reference .
We can have a new line item which matches Target and Source in this case and have LOOKUP of that line item .

Plz let me know if this works .

Good luck .

ChrisAHeathcote

@Human008

Your mapping needs to be a list formatted line item which bridges the gap. If you are using a LOOKUP then it needs to be the same format as the source dimension which is missing from the target. The dimensions of the mapping module must be present in the target too.

Chris

Human008

Thank you Guys, I missed "time" in the other module and I got it.

Thanks for your Time and effort.

Quick Links

Can you help?

Unanswered questions

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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…