The Database tab contains settings concerning the connection to the SQL server.
SQL Server Connection String
A string that indicates the connection points to the Panorama database where information (such as view caches, user states, connection tickets) used by the BI server is stored.
After editing the string, you need to restart the BI server.
Keep User State in SQL Server
When a user opens a view, a user state is created for that user on the server, containing user information, the current view state and previous five view states (to support undo). The state can be kept either in memory or in an SQL table.
To store user states in the SQL server, select the Keep User State in SQL Server check box. After selecting (or deselecting) this option, you need to restart the BI server.
Store user states in the SQL server when:
§ One server should support thousands of users (there can be a memory issue when all user states are in memory).
§ Using load balancing with no affinity. In this case a client may reach Computer A for a drilldown, and then Computer B for slicing. The user state has to be stored in a place reachable by both computers: an SQL user state table.