Strategy ONE

Limiting Element Caches by Database Login

This setting allows you to ensure that users with different data warehouse logins cannot share element caches. When this feature is used, the element cache matching key contains the user's database login. Only users with the same database login are able to share the element caches. Before you enable this feature, you must configure two items.

  1. The user must have a Warehouse Login and Password specified (selecting the Authentication tab in the User Editor).
  2. The project must be configured to Use linked warehouse login for execution (in the Project Configuration Editor, select the Project definition: Advanced category).

If both of these properties are not set, the users will use their connection maps to connect to the database.

To Limit Element Caches by Database Login

  1. In Developer, log into a project. You must log in with a user account that has administrative privileges.
  2. From the Administration menu, point to Projects, and then select Project Configuration.
  3. Expand Caching, expand Auxiliary Caches, then select Elements.
  4. Select the Create element caches per passthrough login check box.

The new setting takes affect only after the project is reloaded or after Intelligence Server is restarted.