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.

einas.ibrahim

Hello @taku.s 

The issue is not in the "Applies To" area. According to the implementation, you are using dimensions where probably you need to.

When you add 2 dimensions to a module what you are essentially saying is ..... There is a value in each intersection of the 2 lists for example:

List A
A1
A2

List B 
B1
B2

If you add these 2 dimensions to a module then the expectation is there is a meaningful value for each the following combinations
A1 B1
A1 B2
A2 B1
A2 B2

I can vaguely understand what you are trying to accomplish, and it is clear that the 3 lists don't work together in the way expected. There is a lot of sparsity - empty cells- which tells me the intersection between the 2/3 lists doesn't have a value.
My guess is List B could be changed to an attribute or so.

 

Could you please elaborate further on the use of the lists and what is the business issue/case you are trying to implement and what is the expected outcome?
This way we can guide you to the best design.

taku.s

Hi @einas.ibrahim 

 

Thank you for your reply.

 

I'm sorry for the poor explanation..

 

In this example, I want to get the "Actual" of List B-Flg1,List B-Flg2,List B-Flg3, which is calculated by the SUM function in the record of List A for each Item List.
So, in order to realize that, I think that it is necessary to add LineItem-formula:ITEM(List A)-for displaying List A.

 

Best regards,

taku

einas.ibrahim

Hi @taku.s 

Don't worry about the explanation, I'll be here until we figure this out.

Can you please give me the relationship of these lists to each other. You don't have to reveal any business information. You can say Liat A is fruits and list B is - I don't know - crate size. Something to help us understand the relationship and hence the business logic to determine the best solution.

taku.s

Hi, @einas.ibrahim 

 

Thank you for your kindness.

 

The relationship of these lists to each other is ...

Item List is Account.

Item A is Category.

Item B is Project.

 

Although not included in the above figure, Category (List A) is set in Property instead of the parent item of Project (List .

 

Best regards,

taku

millar

hey enias, your suggestions helped me , was running in similar things.

 

@einas.ibrahim wrote:

Hello @taku.s 

The issue is not in the "Applies To" area. According to the implementation, you are using dimensions where probably you need to.

When you add 2 dimensions to a module what you are essentially saying is ..... There is a value in each intersection of the 2 lists for example:

List A
A1
A2

List B 
B1
B2

If you add these 2 dimensions to a module then the expectation is there is a meaningful value for each the following combinations
A1 B1
A1 B2
A2 B1
A2 B2

I can vaguely understand what you are trying to accomplish, and it is clear that the 3 lists don't work together in the way expected. There is a lot of sparsity - empty cells- which tells me the intersection between the 2/3 lists doesn't have a value.
My guess is List B could be changed to an attribute or so.usps tracking usps tracking

Could you please elaborate further on the use of the lists and what is the business issue/case you are trying to implement and what is the expected outcome?
This way we can guide you to the best design.

---

 

einas.ibrahim

I’m glad It helped.

Let me know if I could be of help.

millar

sure !! my pleasure..