The DB Admin tab enables you to connect ContentReporter to your database, and to configure database rollups.
The following screen shows the database rollup properties on the DB Admin tab.
The following table describes the database rollup properties.
Property
|
Description
|
|---|
Rollup Frequency
|
The frequency (Daily, Weekly, Monthly) of database rollups.
You can specify in the Number of Days to Keep Hourly Data field how often all hourly data in the database is converted into monthly data.
The Set Schedule button launches the Rollup Scheduled window to specify the rollup frequency.
|
Number of days of hourly data to keep
|
The minimum number of days of hourly data to keep available for reports in your database. Immediately after a database rollup, you have exactly this many days of hourly data in the database. After a rollup, the hourly data in the database increases by one day each day until the next rollup.
For example, if you schedule database rollups for the 1st and 15th of the month and specify to keep 33 days of hourly data in your database, you have 33 days of hourly data immediately after the rollup on the 1st of the month, 46 days of hourly data on the 14th day of the month, and then 33 days of hourly data immediately after the rollup on the 15th day of the month.
|
Number of months of monthly data to keep
|
The number of months of monthly data to keep available for reports in your database. Immediately after a database rollup, you have exactly this many months of monthly data in the database.
For example, if you set this number to six months and schedule a rollup to occur on October 1st, you will have monthly data available in your database for reports for the months of April through September.
|
Number of days of billing data to keep
|
The minimum number of days of billing data to keep available for reports in your database. Immediately after a database rollup, you have exactly this many days of billing data in the database. After a rollup, the billing data in the database increases by one day each day until the next rollup.
|
Number of days of Streaming data to keep
|
The minimum number of days of streaming data to keep available for reports in your database. Immediately after a database rollup, you have exactly this many days of streaming data in the database. After a rollup, the amount of streaming data in the database increases by one day each day until the next rollup.
|
Apply and OK buttons
|
Enables you to save changes to the ContentReporter server. If you click OK, you return to the Administration page. If you click Apply, you remain on this tab. If you want to make multiple, interdependent changes to settings on this tab, you must click Apply after each interdependent change.
|
