Transfer data from one combination of dimensions to the rest of them

Highlighted
Certified Master Anaplanner

Transfer data from one combination of dimensions to the rest of them

Hi Anaplanners,

 

Let's say we have a module with Dimensions A and B, they have 1000 list members each (for example), and a couple of line items, which user populates manually. Only ONE combination (intersection) of list items has data; the rest of the module is impty. I need to copy this data to all empty cells in this module.

 

What is the best way to do it?

 

Cheers,

Dmitry

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Transfer data from one combination of dimensions to the rest of them

@DmPasko 

 

Step 1: Create a global module which should be dimensionless. Here the user inputs the value in one cell

Misbah_0-1591699205931.png

Step 2: In your existing module refer the numbers from global module

Misbah_1-1591699228606.png

Hope that helps

 

Highlighted
Super Contributor

Re: Transfer data from one combination of dimensions to the rest of them

hi @DmPasko 

 

put the value in a separate module- with no diensions and then refer it, all dimensions and all intersectons will have same value