Adding a New Field From an Existing Record in the Query

To modify the simplified analytic query by adding a new field to the query:

1. Search and open the required query from the Query Manager. Under the Query tab, the records associated with the query are listed.

2. Expand the records to see fields associated with each record. The list of fields for a record also includes fields not selected to be used in the query.

3. Select a new field to be added to the query from this list. You can verify the selected field appears under the Fields tab and the View SQL tab of the Query Manager.

4. Verify the new field is also shown on Selecting a Data Source- Step 2 page of the Pivot Grid Wizard as a Data Source Column. Step through the wizard and save the model.

5. Open an existing simplified analytics report that uses the same query and pivot grid base template. The report has no change.

6. Click Edit button on the report. Note that the new field is listed. You can make further modifications to the report selecting the new field on the report.

   The new field added to the query will be available when you create a new analytics using the same query.