Archives of the TeradataForum

Message Posted: Fri, 21 Jun 2002 @ 13:57:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We use Microstrategy as our user interface to Teradata and up till now have been passing the individual's logon id to Teradata. With 300 users, the Intelligent server frequently runs our of memory because it needs to build separate caches for each user. Also, element browsing takes a long time if long running queries are hogging resources in Teradata. Microstrategy currently has no way to pass a separate resource partition account code for element browsing versus report running.

We are rethinking our strategy and have decided to create group logon ids for different departments and projects, so users in the same group can share the element cache. To facilitate element browsing, we would like to prebuild the element cache each morning before the users log on to the system.

Has anyone written anything or know of a tool to get this done?

Thank you.

Yonina Schuchman

	<Prev	Next>		<<First	<Prev	Next>	Last>>