## Products

Webtrends Analytics (all)

## Cause

Understanding what to adjust a table limit to can be a difficult task. The information below, should help subside some of this difficulty.

## Resolution

**Adjusting the 1D limit:**

dimension0maxanalysiselements = 20000

dimension0maxreportelements = 4000

When adjusting a 1D limit, the simplest thing to remember is that the dimension0maxreportelements can be no higher than 20% of what the dimension0maxanalysiselements is. In the example above, 4000 is 20% of 20000.

Lower than 20% is fine as well. Just remember, the report limit can be no higher than 20% of the analysis limit.

**Adjusting the 2D limit:**

This is where things become a little more tricky.

dimension1maxanalysiselements = 1000 – We don’t trim this, and this is “1000 analysis elements per 1st dimension element“dimension1maxreportelements = 100 – This is set to display the top “100 of the top 1000 (above) per 1st dimension element” dimension1maxanalysiselementsglobal = 50000 – This value and only this value gets trimmed in the second dimension

All the elements in the second dimension are grouped into one large bucket. For example –

Dimension 1 = Bags

Dimension 2 = Color Hits

Duffel | |

Red | 8 |

Blue | 7 |

Green | 6 |

Brown | 5 |

Black | 4 |

Backpack | |

Brown | 3 |

Green | 2 |

Black | 1 |

Red | 1 |

Blue | 1 |

This is how the above is grouped in the globalanalysislimit (one large bucket), which will be a total of 10 elements in the bucket.

Duffel | Red | 8 |

Duffel | Blue | 7 |

Duffel | Green | 6 |

Duffel | Brown | 5 |

Duffel | Black | 4 |

Backpack | Brown | 3 |

Backpack | Green | 2 |

Backpack | Black | 1 |

Backpack | Red | 1 |

Backpack | Blue | 1 |

**Example Scenario 1 – Good**

dimension0maxanalysiselements = 200dimension0maxreportelements = 40dimension1maxanalysiselements = 1000dimension1maxreportelements = 100dimension1maxanalysiselementsglobal = 50000

Let‘s say there are only 40 total elements that will ever make it into this 1d report. Of these 40 elements, it’s possible that there can be a total of 150 in the 2nd dimension per 1st dimension.

This means that if all the conditions were right, we would take 40 and multiply it by 150. This would equal a total of 6000 that would go into the “GlobalAnalysisLimit”. As 50k is the limit, this is going to be ok as it won’t trim.

**Example Scenario 2 – Not good**

dimension0maxanalysiselements = 20000

dimension0maxreportelements = 4000 dimension1maxanalysiselements = 1000

dimension1maxreportelements = 100

dimension1maxanalysiselementsglobal = 50000

Let’s say there can be a total 4000 elements in the first dimension and per first dimension, there can be a total of 700. If there are 700 elements per 1st dimension and 4000 elements in the 1st dimension, this will be a total of 2.8 million elements trying to cram itself into the “GlobalAnalysisLimit” bucket, which is set to 50k. We probably would want to re-think the strategy on this report. What strategy depends on the customer?s needs.

There are many different scenarios out there and we can?t possibly list them all. However, we can be prepared by asking a few questions and knowing one basic rule.

Rule: The report limit can be no higher than 20% of the analysis limit

Questions to ask –

1. How many elements do you expect in the first dimension.

2. How many elements do you expect in the second dimension, per first dimension.