Pivot - Connection & Data Model

To specify connection, data model and widget type:

  1. Click Create Widget from the Add Widget screen. The Connection & Data Model screen displays.

 

database_model_PT_NEW.jpg

Connection & Data Model screen

 

  1. Select the  database connection from the Connection list. The Database is automatically displayed based on the database connection.

  2. Enter the number of records to-be-viewed in the preview in Max. Records For Preview. By default, the maximum number of records is set as 1000.

  3. Select All Records option to display all records of all the fields.

  4. Add a data model from the Select Data Model(s) list to the selection list.

  5. To search for a specific data model, enter the name of the data model in text box and click the Find Data Model icon FindReports.gif.

  6. Select Pivot as Widget Type.

  7. Click Next to display Select Columns screen.