Connection and Data Model

During the widget creation process, you can specify the widget type as pivot. You can select the connection and data model, select columns, define data sets, design the widget, set widget properties, and set exceptions

 

To create a pivot widget:

  1. On the Add Widget page of the Create Dashboard menu, click Create Widget. The Connection & Data Model page is displayed

PT_-_connection.jpg

 

  1. From the Connection drop-down list, select the connection. The database name is automatically populated in the Database text box and the data models are displayed in the Select Data Model(s) section.  

PT_-_connection_1.jpg

  1. If you need to increase the number of records retrieved from the database during widget design, do one of the following:

  2. Modify the number of records in the Max. Records for Preview text box. The default number of records (1000) indicates that the first 1000 records returned by the data model are used during the widget creation process.

          - Or -


note.jpg Note:

During widget design, data is retrieved from the database for determining the columns available and for use in presenting a preview of the widget. The Max. Records for Preview text box and the All Records check box define the number of records that are retrieved during widget design.

Selecting the All Records check box loads all records. This may delay widget design time. You cannot enter a value in the Max. Records for Preview text box if the All Records check box is selected. You must clear the check box to enter the value


  1. Select the Sort Columns check box, if you want to list the columns in alphabetical order

 


note.jpg Note:

The columns are displayed in the order they are returned from the database. Listing the columns in alphabetic order makes it easy for you to find the column you need from the column listing, even if you are not familiar with the database


  1. In the Select Data Model(s) section, click Plus_Plus.jpg  next to the data model to select it. The selected data model appears on the right.

 

PT_-_New_1.jpg

 


note.jpg Note:

 You can select only one data model for the pivot widget


  1. Click Pivotas the widget type. Selection is denoted by a  TICK.jpg mark that appears next to Pivot.

PT_new_2.jpg

  1. Click Next. The Select Columns page is displayed

 

 

top.jpg

<<Pivot Table Overview | Select Columns>>