Deferring Interactive Reporting Web Client Connections

When an Interactive Reporting document file is opened in Interactive Reporting Web Client, a connection is made to the database immediately using the criteria set in the Interactive Reporting database connection file. This has been the default behavior for the Interactive Reporting Studio and Interactive Reporting Web Client since Release 8.2. Interactive Reporting Web Client optionally enables you to defer the connection to the database until the query is processed. That is, the credentials for the user are obtained following the rules established by the EPM Workspace and by the publishers of the Interactive Reporting document file and document content. For example, if the Interactive Reporting database connection file associated with the query is set to prompt the user when the Interactive Reporting document file was published, the user is prompted; if at publishing time the credentials were supplied (Specify Now), then those credentials are used, and so on. If you defer the connection to the database, the deferment is not saved with theInteractive Reporting document file. When it is reopened, an immediate attempt to connection to the database is made.

Note:

Deferring the connection to the database in Interactive Reporting Web Client, can only be set in the Interactive Reporting Studio. The setting only affects Interactive Reporting document file opened in Interactive Reporting Web Client, and not in the Interactive Reporting Studio

  To defer the connection to the database for an Interactive Reporting document file in Interactive Reporting Web Client:

  1. Select Tools , then Connection, and then Web Client.

    The Web Client dialog box is displayed.

  2. To defer the connection to the database until the SQL is processed, select Defer connection to database until used to process SQL. This was the default behavior before 8.2 and click OK.

  3. Optional. To reset the connection option to the default setting, select Immediately connect to database. (This is the default behavior for version 8.2 and later and is recommended and click OK.