Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2004 @ 13:34:40 GMT


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


Subj:   Re: Drill Through in PowerPlay Cognos
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, March 18, 2004 08:32 -->

Yes, there are two ways of doing this.

First - Embed a common userid/password in the catalog or the odbc connection thereby not requiring a userid/password. However, note that using this method that all users will use the same userid/password and therefore any database security will not be in effect. Also note that shared temporary space may be at risk if you have a large number of users running a SQL query at the exact same time.

Second - Using Cognos Access Manager you can setup userid/passwords for all of your users (as appropriate) and then when the user drill's through to the report it will pass the userid/password for them. This solution ensure database security is respected and that the temporary table spaces are more optimally managed.



     
  <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: 15 Jun 2023