Products
Webtrends Analytics 8.x
Webtrends Analytics 9.x
Cause
You have a need to find out the ODDB table numbers of reports. These are different than the table numbers found in the dbinfo and can only be found by running an export.
Resolution
To find out what the ODDB table numbers are for each report, there is a manual export that needs to be performed via the command line.
1) For 9.2b, navigate via the cmd line to ./modules/analysis/engine/9.2b/
For 9.2a, navigate via the cmd line to ./modules/analysis/engine/9.2a/
For 8.7d, navigate via the cmd line to ./modules/analysis/engine/8.7d/
2) Type the following command:
wtrs64.exe -createcsv file=C:\profile.csv period=2011\m02\d07
Note: Period is the date you want to export and is the guid of the profile.
The csv file will export to root of C in the above command, but can be changed to a different location. The file will have a large amount of information in it, in addition to table numbers.
This is an example of what one table number will look like
TableNumber Table Name
1 REPORT_TOP_REVERSE_PATHS_USERS
TableNumber Table Name
2 REPORT_TOP_DOCS_USERS
TableNumber Table Name
3 REPORT_TOP_DOCS_HITS
We can see from the above that
TableNumber 1 isREPORT_TOP_REVERSE_PATHS_USERS
TableNumber 2 isREPORT_TOP_DOCS_USERS
TableNumber 3 isREPORT_TOP_DOCS_HITS
1) For 9.2b, navigate via the cmd line to ./modules/analysis/engine/9.2b/
For 9.2a, navigate via the cmd line to ./modules/analysis/engine/9.2a/
For 8.7d, navigate via the cmd line to ./modules/analysis/engine/8.7d/
2) Type the following command:
wtrs64.exe -createcsv file=C:\profile.csv period=2011\m02\d07
Note: Period is the date you want to export and is the guid of the profile.
The csv file will export to root of C in the above command, but can be changed to a different location. The file will have a large amount of information in it, in addition to table numbers.
This is an example of what one table number will look like
TableNumber Table Name
1 REPORT_TOP_REVERSE_PATHS_USERS
TableNumber Table Name
2 REPORT_TOP_DOCS_USERS
TableNumber Table Name
3 REPORT_TOP_DOCS_HITS
We can see from the above that
TableNumber 1 isREPORT_TOP_REVERSE_PATHS_USERS
TableNumber 2 isREPORT_TOP_DOCS_USERS
TableNumber 3 isREPORT_TOP_DOCS_HITS