Database Reference
In-Depth Information
As you can see in Figure
5-26
, we have added a database and assigned a charge plan and cost center to it.
You will notice, though, that there has never been a collection done on this target. Collection on this target can be
done manually via the Action menu option of On-Demand Data Collection. This will create a job within Enterprise
Manager that runs immediately. When the job completes, the collection status will change to Succeeded.
After some time, it will be handy to identify and provide reports that will show how resources are being used.
This can be done on the last tab of the chargeback interface, the Reports tab. This tab allows you to view and publish
chargeback reports that can be used as a powerful analytical tool for tracking resource usage and charge distributions
(see Figure
5-27
).
Figure 5-27.
Chargeback report view
The Reports tab shows a lot of detail for resources. In Figure
5-27
, you see a breakout by cost center and target
type. Further to the right, you will see a breakout by resource. At the bottom of the screen, in the Details section, is a
table that provides detailed information about resources that have been configured. Everything on the reports table is
searchable and reportable at the top of the screen.
In addition to the report provided on the Reports tab, reports can be pushed with Oracle Business Intelligence (BI)
Publisher. This allows Enterprise Manager to provide more-sophisticated reports in formats that can be e-mailed.
With BI Publisher installed, the reports that are produced can be published to any number of formats (including
HTML, PDF, Word, Excel, and PowerPoint) by clicking the Publish Report button. Figure
5-28
shows a sample report
that is published from the reports table in the Chargeback interface.
