How to reduce the cell capacity

taku.s

Hi,everyone.

 

I would like to reduce the cell capacity by reducing the module "Applies To".

 

"List A", "List B", and "Item List" are set in "Applies To" of "Module A". Time Scale is Month.
"List B-Flg1 Actual" is set to the value of "Actual" if the flag of "List B" is TRUE. (The same applies to "List B-Flg2 Actual" and "List B-Flg3 Actual")
In order to reduce the capacity, I would like to reduce "Applies To" of LineItem so that the same result as before modification can be obtained.

 

I'm very in trouble because of the huge increase in cell capacity.

Could you tell me the good solutions?

 

Best regards,

taku

einas.ibrahim

Hi @taku.s 

If I understand you correctly, an Account can have only ONE category. In this case it should be a property or an attribute, not another list dimension.
Example:

Accounts List

-- Account 1
--Account 2

--Account 3

--Account 4

--Account 5

--Account 6

--Account 7

--Account 8

--Account 9

--Account 10

Categories List

-- Category 1

-- Category 2

-- Category 3

-- Category 4

-- Category 5

 

And here is the actual values 

 

When I use the 2 dimensions in a module, here is what the results look like: 

 

Look at all the empty cells...These are unnecessary intersection cells that count against the module size but they will never be used.
If the Account list was representing a Sales Reps for example and the Category list representing Location where they work

We will have a combination like this 
Einas - New York
John - Boston

Jane - San Francisco

Smith -- New York

 

Einas will always have New York as the location where she works we can't have another entry that says Einas - Boston. More than one person can have the same location Einas, Smith --> New York. But that still doesn't warrant using the 2 dimensions together.

Here is a visual of how you would implement this the right way with Category as a list formatted line item i.e.an attribute or a property of Account-

 Let's compare the cell count for each module

 

 

That's a 60% reduction for such a small list.

 

Bottom Line

Differentiate between a dimension and a property and implement accordingly

Use multiple dimensions when the intersection between all the combination of the first and second lists have meaningful values.

 

That should take care of your Account and Category lists. Make the change, decide what to do with the Project list, and let me know if you have any questions or you want me to explain any of the points in this list further.