The Ad Hoc View panel provides tools that allow you to control what data is included in a view, and how it is organized.

Along the top of the panel, there is a tool bar and two drop-down menus:

  • The first drop-down menu allows you to reset the view type. Use this menu to select TableChart, or Crosstab. You can change the view type in the Ad Hoc Editor during the design, or when you reopen the design for editing.
  • The next drop-down menu contains options for displaying a subset of the available data (Sample Data, all available data (Full Data), or none of the available data (No Data) in the view. Using the sample data can make the design process quicker by loading less data. Use the subset for initial design; use the full set for refining layout elements such as column width.

By default, the editor displays only a smaller, sample set of the data in the table. Use the drop-down menu to select Full Data to view the full set of data.

Depending on the configuration, Zoola™ may load a Topic or Domain's entire result set into memory when you edit the view. Zoola™ may also run a report from the results. If the data policies and other options that control Zoola™ memory are disabled, ensure that each Topic or Domain returns a manageable amount of data, given the environment's load capacity. Alternately, you can change the server's configuration


The tool bar at the top of the panel provides access to many of the functions in the Ad Hoc Editor, outlined in the following table:

Icon

Name

Description

Display Mode

Click this icon to hide the editor interface. This mode provides a subset of the editor's full feature set.

Save

Place the cursor over this icon to open a menu of save options.

Export

Place the cursor over this icon to open a menu of export options.

Undo

Click this icon to undo the most recent action.

Redo

Click this icon to redo the most recently undone action.

Undo All

Click this icon to revert the view to its state when you last saved.

Switch Group

Click this icon to change the way groups are displayed.

Sort

When working with tables, click this icon to view the current sorting and to select fields for sorting data.

Input Controls

Click this icon to see the input controls applied to this view.

Page Options

Place the cursor over this icon to open a menu of page-level options:
 

  • Change whether to display the Layout Band. 

  • Change whether to display the title area. 
    In tables, you can also hide or show the detail rows when the data is summarized. This option is available only if the table includes grouped columns.

View SQL/MDX Query

Click this icon, if it is available, to view the relevant SQL queries.



The Layout Band

Directly beneath the tool bar is the Layout Band. Here, there are two fields. These fields have different labels and functions, depending on the type of view you are creating:

  • For tables, these fields are  Columns and  Groups

  • For charts, these fields are  Columns and  Rows

  • For crosstabs, these fields are  Columns and  Rows

You can drag and drop fields and measures from the Data Source Selection panel into these boxes to populate your Ad Hoc view.


Managing Canvas Options

When working with a table or chart view, the Canvas Options selector appears below the Layout Band, to the left of the view title. This tool allows you to control the level of detail displayed in your table or chart. Click the Display Settings icon to display the options available for your Ad Hoc view type.
For tables, the Canvas Options selector includes the following options:

  • Detailed Data: displays table details only. 

  • Totals Data: displays table totals only. 

  • Details and Totals: displays both details and totals. 

For charts, the Canvas Options selector includes the following options:

  • Chart Types: displays the available chart types. 

  • Chart Format: displays formatting options. 
     

 

Viewing the SQL Query

You can to look at the SQL query for your view to verify what data users are hitting. If you have the proper permissions, you can do this in the Ad Hoc Editor with the View SQL Query button .
The query is read-only, but can be copied onto a clipboard or other document for review.

In the Ad Hoc Editor tool bar, click the View SQL Query button 
The View Query window opens, displaying the SQL query.