Products
Webtrends Analytics 9.x
Webtrends Analytics 8.x
Webtrends Enterprise 7.x
Cause
Creating a report to display Webtrends usage metrics requires custom reports. Webtrends 7, Enterprise edition is therefore the only option for this kind of reporting among the versions of Webtrends 7.
Resolution
1. Navigate to Administration > System Management > Global Roles > UI Server and check the box for “Enable Tomcat logging.” After making this change restart the Tomcat and Apache services using the Windows Services snap-in on the Webtrends server.
2. On the server, under Start > Administrative Tools > Data Sources (ODBC), on the System DSN tab, select “Add…” and select MySQL ODBC 3.51 Driver for the data source.
3. Use localhost or the server name in the Server field. Enter the name of the MySQL user account in the User field. By default, this is “Administrator”. Enter the password used for this account at the time of installation, and in the Database field enter “wtmaster”. The other fields are optional.
4. In the Webtrends user interface, navigate to Web Analysis > Report Configuration > Custom Reports > Data Sources. Create a new Data Source and set the “Type” to Database, the “Source Database Type” to SQL, and type in the name of the data source created in step 3. Enter the user name and password for the database user account, then save the changes.
5. Navigate to Web Analysis > Report Configuration > Custom Reports > Dimensions and create a new dimension based on Query Parameter, with the value “userid” in the Parameter Name field.
Select Advanced (where applicable), then check the box for “Translate Substring Retrieved Above” and select the
At the bottom of the “Based On” screen, check the “Translate Substring Retrieved Above” check box, select the data source created in step 3 from the Data Source drop-down list. Add “UserID” in the Key Column field, “UserName” in the Value Column field, “wt_user” in the Table column and save the dimension.
6. Create a new custom report using the dimension created in step 5 and whichever measures are preferred.
7. Navigate to Web Analysis > Options > Session Tracking. Select New Session Tracking definition. Enter a name in the Description field, then select the radio button to Use the following alternate method(s) and check the box for Parameter Match. Select Next, and on the following screen, enter “userid” in the Track sessions by the specified parameters field. Save the new Session Tracking definition.
8. Navigate to Administration > Data Sources. Create a new Data Source of type Web: Log File. Provide it with a name and enter the path to the Webtrends Tomcat logs. The default path is as follows:
C:\Program Files\Webtrends\common\jakarta-tomcat\logs\
The default log file name will appear similar to the following:
tomcat_2010-10-01.log
Note: Other log files in this location, e.g., stderr.log and stdout.log, are not compatible with Webtrends and should not be included in analysis.
It is recommended that Tomcat logs are moved to another location before analysis, and that the data source only points to the log files in this alternate location. This is because the live Tomcat log file grows continuously, and if regular analysis of the live log file occurs some log file entries may be counted more than once. This is due to Webtrends’ ability to recognize log files it has analyzed before based on the file contents, but if the contents change it will appear as a new log file, and as a result, the same live log file will be considered a new log file every time it is analyzed. The accuracy of any report metrics requires all log files in the data source to be static and finalized.
Save the changes.
9. Under Web Analysis > Report Designer > Templates, edit the template the profile will use and under the Content tab, select Add Report. Use the Custom Report Library (alphabetically) option in the drop-down menu above, then check the box for the custom report created in step 6. Select a location for the report, if necessary, then save the changes.
10. Create a new profile using the data source created in step 8, the session tracking definition created in step 7 and the custom report created in step 6.
11. Save the profile and analyze. The custom report will now display metrics for Webtrends usage for all Webtrends users.