This section discusses basic functionality of the Ad Hoc Editor. Read to learn about:
Selecting report content
Formatting table appearance
Viewing and running a report in the editor
The Ad Hoc Editor also is helpful for exploring and analyzing data; for more information, see the section titled "Exploring and Analyzing Data in the Ad Hoc Editor."
To design a table in the Ad Hoc Editor:
From the Analytics Getting Started page, click Create a Report.
The Topics and Domains window appears.
On the Domains tab, expand Organizations in the hierarchy, and then select a Domain.
Select Table, and then click Open Report.
The Ad Hoc Editor appears, showing available fields (in the left panel).
At the top of the table (Click to Add a Title), click in the area and enter a title for the report, and then press Enter.
Data for each field appear as you add columns to the table.
To change the list of fields available to the report, click (select...). From the Change field selection dialog, you can select additional fields from the Available list.
To view report data in chart form, click the Chart tab.
In the Report Name field, enter a report name.
Accept the default value for Location Folder, or click Browse to select a new location.
In the Description field, optionally enter a description for the report.
A range of options are available to change the appearance of a table. You can change:
Report style (colors)
Group and column labels
Spacing (add "spacers")
To format a table in the Ad Hoc Editor:
To change report style:
In the Search field, enter the saved report name, and then click Search.
The Search page appears, displaying objects matching the entered text.
In the Repository pane, right-click the report, and then select Open in Designer from the options menu.
The report appears.
Select a style, and then click Close.
To change the label for a group or column:
To resize a column:
Click a column header.
Borders appear on the column.
Move the cursor to the column edge until the resize arrows appear, and then drag the border left or right.
The column resizes to the selected size.
To change the format of data in a column:
The following example shows how to create an ad hoc report. It illustrates how physical server resources are used, and more specifically, how resource usage changes over time for a server. The value of this chart is that it allows you to determine if additional capacity is required by looking at the trends. You will select a single server and create column charts showing one month of data for CPU utilization, which is always between 0% and 100%.
Steps in this example include:
Inspecting the MySQL database
Creating a Domain
Creating an ad hoc report
This optional step allows you to test queries and determine a strategy for creating the Domain and ad hoc report.
Filtering by date range and averaging of CPU utilization values is done when creating an ad hoc report. Therefore, the Domain that is created will resemble this SQL query:
View the repository.
Ctrl-Click to add a domain to the Zenoss > Domains folder.
Launch the Domain Designer. In the wizard, make selections or enter information as follows:
Tables - Enter
Derived Tables - Click New, and then paste in the following lines:
SELECT device_name, date_key, cpu_pct_value FROM fct_cpu__pct JOIN dim_device USING (device_key) WHERE device_name="test-ubuntu804.zenoss.loc'
Click Run, and then Create.
Display - Select
device_name, and then click Add Selected. Change the labels to Date, CPU Utilization, and Device.
This ad hoc report will be a chart; however, choose Table, which allows you to more easily drag and drop fields before switching to Chart.
Build the ad hoc report by using the Ad Hoc Editor:
From the Domains tab, select a domain, select Table, and then click Choose Data to launch the editor.
Make selections and enter data to define the report:
On the Data panel, select Date, CPU Utilization, and Device, and then click Next.
On the Filters panel, click Date, and then click New Condition. In the Comparison column, select "Is After." In the Value column, select last month's date, and then click OK.
On the Filters panel, click Date, and then click New Condition. In the Comparison column, select "Is On or Before." In the Value column, select today's date, and then click OK.
Click Open Report.
Drag Date to the center of the report.
Drag CPU Utilization into the space to the right of the newly displayed dates.
Click the Chart tab.
The data appears in chart form.
Right-click the chart, and then select Change Summary Function > Average.
When you have created a table, chart, or crosstab, you can save it in the repository for future use. In the Ad Hoc Editor, you can: