Copy a value (year dimension) to a Monthly dimension module and Version dimensions

Hi,
We are struggling to find a way to get our "Bill Of Materials" in Anaplan.

I would like to enter values for a Bill Of Material for our products with a year dimension. The consumption of the raw materials is valid for the whole year. Furthermore the Bill of Material is valid for all Custom Versions:
Below is the idea how the Bill of Material should look like (the raw materials is a list)

After completing the consumption, these values should be imported to a module with a monthly dimension and custom versions.

In the monthly module we calculate the cost price of the product. This is based on the Bill of Material and the raw material price of that month.
So far, I did not manage to get the consumption of the materials in above module in all months and all versions.

It would be great if anyone could help me to solve this :-)

Thanks in advance for looking into our issue!

Jo Maassen

Accepted answers

Sai_Bharadwaj_Venati

Hi,

There are different ways to solve this problem: -

You can use simple Yearvalue formula to bring data from module 1 to module 2
If you dont want to use formula → you can create a staging module with all dimensions similar to output module and apply yearvalue formula → import data into output module based on Action run

I would prefer approach 1

pyrypeura

I'd assume that you want store these to module by version and month in case these values change during the year? If this is the case then you'd need to do as @Sai_Bharadwaj_Venati suggested as option 2 and import values to target module through a staging module.

Option 1 suggested is viable only if values won't change during the year or you don't need to calculate anything based on historical values.

All comments

Sai_Bharadwaj_Venati

Hi,

There are different ways to solve this problem: -

You can use simple Yearvalue formula to bring data from module 1 to module 2
If you dont want to use formula → you can create a staging module with all dimensions similar to output module and apply yearvalue formula → import data into output module based on Action run

I would prefer approach 1

pyrypeura

jo_maassen_1

Hi both,

Thanks for your quick response.

The yearvalue formula works as you described. I tried the formula before, but then it gave me the total value of all materials. But now it shows exactly the result that i want to see.

I think i stick with the formula for now. If we would need to change the Bill of Material during the year, we can always create the staging module and do a copy.

Thanks again for your help!

best Regards,

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!