Limiting Element Caches by Database Connection

In most cases, users connect to the data warehouse based on their connection maps. By default, all users have the same connection map, unless you map them to different ones with the Connection Mapping editor. When using connection mapping, you can also ensure that users with different database connections cannot share element caches. This causes the element cache matching key to contain the user's database connection.

To Limit Element Caches by Database Connection

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 click Elements.
4. Select the Create element caches per connection map check box.

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

For more information about connection mapping, see Controlling Access to the Database: Connection Mappings.

Users may connect to the data warehouse using their linked warehouse logins, as described below.