Changing User Names and Passwords for Interactive Reporting Documents

An Interactive Reporting document can be imported to obtain credentials for the queries used to connect to the data source in a variety of ways:

No action is required where credentials from queries are obtained from the Interactive Reporting database connection or where a prompt occurs for the credentials. The queries that are replaced continue to prompt or to reference the Interactive Reporting database connection for the credentials.

Explicitly configured credentials may require changes as these credentials may stop working against the new data source. By changing the way the queries are imported in the replacement Interactive Reporting document, you can alter how credentials are handled in the updated Interactive Reporting document. Table 31 illustrates what happens to an Interactive Reporting document that was originally imported to connect to a data source with some explicit credentials, for example, user name=scott and password=tiger.

Table 31. Interactive Reporting Document Before And After Update 

Imported Replacement Interactive Reporting Document

Oracle's Hyperion® Interactive Reporting Document After Update

Explicit Credentials

Connects the query to the data source using new credentials, user name=sa and password=secret, and processes without asking the user for values and without regard to the contents of the Interactive Reporting database connection

Prompt User

Displays a log on dialog box and the user supplies a user name and password to connect

Use Interactive Reporting database connection Default

Connects the query to the data source using the definition in the Interactive Reporting database connection at the time the connection is attempted