Insert Query

Use the Insert New Query dialog box to insert a new query. You can insert the query associated with a master data model, or log on using the current Interactive Reporting database connection file. Additionally, Interactive Reporting Studio users can select another Interactive Reporting database connection file.

To insert a new query:

Select Insert, then New Query.
The Insert Query dialog box is displayed.
Select Master Datamodel to use the master data model associated with the query.
Select Logged on connection to connect to the database using the current Interactive Reporting database connection file.
Select No connection not to connect to any database.
Click Yes.

Option	Description
Master Datamodel	Each time a new query is inserted into an Interactive Reporting document file that contains a master data model, you are prompted to link the new query to the master data model. The benefit is that any changes to the master data model get propagated to all dependent queries that are based on the master data model.
Logged on Connection	Uses the current Interactive Reporting database connection file.
No connection	The new Interactive Reporting document file is not associated with anInteractive Reporting database connection file, allowing you to work offline.
Options	Displays the second Insert Query dialog box. Use this dialog to specify a new or recent Interactive Reporting database connection file. This command is not available in Interactive Reporting Web Client.

To create a new Interactive Reporting database connection file.

Select Insert, then New Query.
The Insert Query dialog box is displayed.
Do not select any options on the first Insert Query dialog and click No.
The second Insert Query dialog is displayed.
Select A New Database Connection File and click OK.
The Database Connection Wizard is displayed.
Follow the instructions given in the wizard.
For more information, see Creating Interactive Reporting Database Connections (.oces)

To create a new Interactive Reporting document file using a recent new Interactive Reporting database connection file:

Select Insert, then New Query.
The Insert Query dialog box is displayed.
Do not select any options on the first Insert Query dialog and click Options.
The second Insert Query dialog is displayed.
Select Recent Database Connection Files.
Select an Interactive Reporting database connection file from the Recent Database Connection Files list.
If you don’t see the desired Interactive Reporting database connection file, click Browse to display the Select Connection dialog box.
Navigate to the desired Interactive Reporting database connection file and click Open.
The Connection Password dialog box is displayed.

Type your user name in the Host User field and password in the Host Password field, and click OK.

Tip:	If you do not have the right Interactive Reporting database connection file to connect to a particular database, ask your administrator to provide the Interactive Reporting database connection file or to help you create an Interactive Reporting database connection file.

To create a blank Interactive Reporting document file with no Interactive Reporting database connection file, select No Connection and click OK.