Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Issue
Why is the 2D Count higher than the 2D Global Analysis Limit?
Resolution
Some reports within Webtrends, including manually created custom reports, include a second dimension. This second dimension, like the first dimension, has a Total Analysis Limit or Global Analysis Limit of what can be included within the table. On occasion, values similar to the following may appear:
2D Count 147187
2D Analysis Limit 500
2D Global Analysis Limit 50000
In this example, the 2D count is higher than the 2D Global Analysis Limit.
In order for the second dimension to populate in a 2D report, the first dimension must be populated. A second dimension, however, does not need to be available for the first dimension to populate. When the first dimension populates, and there’s no data for the second dimension to populate, Webtrends puts a place holder in for the second dimension. If you were looking at the database, you would see something similar to the following appear:
1D
2D Value1 Place holder
2D Value2 Place holder
This place holder will allow the Count for the 2D Reports to look as if it’s going above the table limit, but this is an indication that table space has been reserved for the second dimension.
Example:
A report has a 1D Analysis Limit of 20 and 2D Global Analysis limit is 10. There are no values for the second dimension, so if all 20 values went into the first dimension, there would be twenty place holders (one for each element in the first dimension) in the second dimension, and this would result in a 2D Count of 20. The place holder appears in the “Other” bucket within the table totals.
More Information
It is recommended that the 2D Global Analysis limit be set to a multiple of the 1D Analysis Limit and the 2D Analysis Limit, thereby accommodating the potential number elements.