How to Create a View Configuration

Steps

1. To change the view configuration for a query choose the View tab.

   To create a view for a saved query:

   • choose the query from the Query List on the Overview page

   • press the Edit button

   • click on the View tab.

   The queries current view configuration displays.

2. Declare how you want to view the results of your query.

   You can add three different sections to the view configuration, decide if additional information about the query is shown, and in which order it is shown.

   

   On top there are jumplinks to jump to the corresponding section if it is available. The possible sections are Database Table, Pivot Table and Graphic. The View Configuration section is always visible and allows to switch on the display of the query description that has been entered on the common tab, the filter conditions from the filter list and the resulting SQL statement of the query definition or the content of the SQL tab for advanced queries.

   Pressing Add Database, Add Pivot, Add Graphic adds the corresponding section.

   For some queries, only a subset of the possible view selections are meaningful. For example, if you have only two columns to select from, pivot makes no sense.

   For the Database Table add and choose the columns that you need to display under Name and adjust their Type and Format. The order in which the columns are added will be the order in which the columns are presented. The selections that you make for this report do not affect the filters applied to the data.

   

   For the Pivot Table, add the pivot column, row, and data entries then choose the column Name, Type, and Format. To shift an entry to a different pivot type select it under Pivot Type.

   

   For the Graphic section, you can attach the query data to different chart diagram types. The following chart types are available from the Diagram Type dropdown:

   • Bar Chart,

   • Bar Chart (3D)

   • Bar Chart Stacked

   • Bar Chart Stacked(3d)

   • Pie Chart, Pie Chart 3D

   • Line Chart

   • Line Chart Stacked Line

   There three different diagram types available:

   • Bar

   • Pie

   • Line

   Bar and Pie types can be display with a 3D effect. Bar and Line diagrams can be drawn as stacked diagrams (values on the y-axis summarized).

   

3. Click Save or Save As to save your View configuration to the query.

4. Click Run to run your query.