Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Microstrategy and Teradata Element Caching
 
From:   Yonina Schuchman

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016