Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Cause
Whether visible or not, all standard tables in a profile collect data during analysis. Disabling unneeded tables can make a profile’s analysis more efficient.
Resolution
Although the application allows for tables to be disabled, disabling a large number of tables can cause problems with profiles. It is recommended that these changes are tested and carefully monitored prior to implementing into production. It is also recommended that changes are not made to a profile while it is undergoing analysis.
To disable a table, first identify the Table Name value. To locate the Table Name, open the profile’s _dbinfo.csv file, found in the path below:
\Webtrends\storage\reports\wtm_wtx\datfiles\databases\\_dbinfo.csv.
Open _dbinfo.csv either in a text editor or with Excel (which should make it easier to read). The first of the column headers, “Table Name,” appears on or around line 20, followed by each of the table names:
Table Name
TopWeekdays
TopHours
TopExtensions
TopSuffixes
TopCountries
TopForms
TopDownloads
TopDocuments
TopDirectory
TopCompanies
TopUsers
TopReferers
TopBrowsers
TopPlatforms
TopCities
TopStates
TopVisitors
TopServerErrors
TopClientErrors
TopFormErrors
GeneralStats
TechnicalStats
ActivityStats
TopReferingSites
TopBottom
TopEntryPage
TopExit
TopSinglePage
ObsoleteTopPaths
TopAds
TopAdClicks
TopAdViews
TopSpiders
TopNetscape
TopExplorer
TopUploads
TopAuthUsers
TopBandwidth
TopPaths
TopSearchKeywords
TopSearchEngines
Top404Errors
TopSearchKeyPhrases
TopSearchPhraseEngines
TopContentGroups
VisitorTracking
NewVsReturningUsers
TopEntryRequest
TopQueries
TopReversePaths
TopVisitsByDuration
TopViewsPerVisit
UserSessionStats
TopGeoRegions
VisitorsPerVisitCount
VisitorGeneralStats
TopWAPDevices
TopWAPBrowsers
TopWAPScreenLines
TopWAPResolutions
TopWAPCarriers
TopWAPImageSupport
TopWAPMarkupVs
TopWAPScriptSupport
TopWAPScriptVs
TopWAPWTLS
TopPALMDevices
TopPALMBrowsers
TopStreamPackets
TopStreamWaitForStart
TopStreamUserInteractions
TopStreamConnectionSpeeds
TopStreamServerPacketsSent
TopStreamServerPacketsResent
TopPlayers
TopQuickTime
TopNetShow
TopRealPlayer
TopHiResStream
TopCompanyNames
TopStreamConcurrency
MedianSessionLength
TopContentPaths
TopReverseContentPaths
TopReferingTLDs
TopPages
TopToPopularRoutes
TopFromPopularRoutes
TopBrowserVersions
Make note of the Table Name value for the table to be disabled and then navigate to the following location:
\Webtrends\storage\config\wtm_wtx\datfiles\profiles\
Edit .wlp for the profile(s) for which the tables will be disabled.
Add the following section to the file:
[TableEnabled]
For each table to be disabled, add the Table Name and assign it a value of zero:
TopSearchPhraseEngines = 0
The following example would disable the four legacy search engine-related reports:
[TableEnabled]
TopSearchPhraseEngines = 0
TopSearchKeyPhrases = 0
TopSearchEngines = 0
TopSearchKeywords = 0
Save the changes and close the file. New data will not be added to the profile in all subsequent analyses.
To disable a table, first identify the Table Name value. To locate the Table Name, open the profile’s _dbinfo.csv file, found in the path below:
\Webtrends\storage\reports\wtm_wtx\datfiles\databases\\_dbinfo.csv.
Open _dbinfo.csv either in a text editor or with Excel (which should make it easier to read). The first of the column headers, “Table Name,” appears on or around line 20, followed by each of the table names:
Table Name
TopWeekdays
TopHours
TopExtensions
TopSuffixes
TopCountries
TopForms
TopDownloads
TopDocuments
TopDirectory
TopCompanies
TopUsers
TopReferers
TopBrowsers
TopPlatforms
TopCities
TopStates
TopVisitors
TopServerErrors
TopClientErrors
TopFormErrors
GeneralStats
TechnicalStats
ActivityStats
TopReferingSites
TopBottom
TopEntryPage
TopExit
TopSinglePage
ObsoleteTopPaths
TopAds
TopAdClicks
TopAdViews
TopSpiders
TopNetscape
TopExplorer
TopUploads
TopAuthUsers
TopBandwidth
TopPaths
TopSearchKeywords
TopSearchEngines
Top404Errors
TopSearchKeyPhrases
TopSearchPhraseEngines
TopContentGroups
VisitorTracking
NewVsReturningUsers
TopEntryRequest
TopQueries
TopReversePaths
TopVisitsByDuration
TopViewsPerVisit
UserSessionStats
TopGeoRegions
VisitorsPerVisitCount
VisitorGeneralStats
TopWAPDevices
TopWAPBrowsers
TopWAPScreenLines
TopWAPResolutions
TopWAPCarriers
TopWAPImageSupport
TopWAPMarkupVs
TopWAPScriptSupport
TopWAPScriptVs
TopWAPWTLS
TopPALMDevices
TopPALMBrowsers
TopStreamPackets
TopStreamWaitForStart
TopStreamUserInteractions
TopStreamConnectionSpeeds
TopStreamServerPacketsSent
TopStreamServerPacketsResent
TopPlayers
TopQuickTime
TopNetShow
TopRealPlayer
TopHiResStream
TopCompanyNames
TopStreamConcurrency
MedianSessionLength
TopContentPaths
TopReverseContentPaths
TopReferingTLDs
TopPages
TopToPopularRoutes
TopFromPopularRoutes
TopBrowserVersions
Make note of the Table Name value for the table to be disabled and then navigate to the following location:
\Webtrends\storage\config\wtm_wtx\datfiles\profiles\
Edit .wlp for the profile(s) for which the tables will be disabled.
Add the following section to the file:
[TableEnabled]
For each table to be disabled, add the Table Name and assign it a value of zero:
TopSearchPhraseEngines = 0
The following example would disable the four legacy search engine-related reports:
[TableEnabled]
TopSearchPhraseEngines = 0
TopSearchKeyPhrases = 0
TopSearchEngines = 0
TopSearchKeywords = 0
Save the changes and close the file. New data will not be added to the profile in all subsequent analyses.
More Information
For more information please see the article titled:How do I delete a table from the FastTrends database?