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

Tagged:

Best Answers

  • Misbah
    Answer ✓

    @DmitryP 

     

    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

     

  • Kanishq17
    Answer ✓

    hi @DmitryP 

     

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