PROFILE

Ther are numerous documentations on the web on How to enable SSO for COGNOS. Once it is done some of us still want to be able to access the login page for test purposes or for a certain kind of users (executive secretary for example who need to log on as ‘my favorite boss’).

There is a great simple and easy way to do this but with one side effect, at least in my configuration, COGNOS 10.2+W2008+IIS7.5+SSO+ActiveDirectory, which was very annoying in my case : The pages takes 10 seconds to display.

http://www.inergex.com/blogs/business-intelligence/2011/12/16/getting-around-single-sign-cognos

The trick is to remove the UserId and Password in the example below.
My thinking is that COGNOS tries to use it and throw ‘authentication failures’ for a while until it finally stops and serves the Login page. When there are no login nor password filled in, the redirect toward the login page is almost immediate.

http-equiv=”refresh” content=”0; uRL=http://servername/ibmcognos/cgi-bin/cognosisapi.dll?

b_action=xts.run&CAMUsername=UserID&CAMPassword=Password&h_CAM_action=

logonAs&CAMNamespace=YourNamespace&m=portal/cc.xts&m_tab=w”>

Share

I am french. So why in english?

It would be weigh more convenient to me if I was writing this in my mother tongue, in french, so why bother?

Because we have to face it, our empire is not ruling the world anymore, at least since napoleon ;)

So if I want people to be able to read me or if I want to share and to learn by having feedbacks from the big majority, it has to be in english.

So thank you for your understanding, I’ll do my best to be clear.

Excellent webinar by Randolf Geist :
“When it comes to writing efficient queries there are a few key concepts that need to be understood. One of them is the Oracle Cost-Based Optimizer (CBO). Although it’s called a cost-based optimizer it’s actually not the cost we need to focus on primarily to understand why the optimizer makes certain decisions.

In this webinar, you will learn the basics of the CBO, see why it is crucial that the optimizer’s picture of the data fits reality, why cardinality and selectivity estimates matter so much, and which key concepts the optimizer’s model surprisingly doesn’t cover (yet).

Live demos throughout the presentation will enable you to see the CBO in action, and you will learn about leading the optimizer in the right direction when your knowledge of the data is better than the optimizer’s.”

A live Q+A session with Randolf Geist follows the presentation.

http://allthingsoracle.com/oracle-cost-based-optimizer-basics-webinar/

Certifié Oracle OCP et Microsoft MCSA+ s

 

 

;

Experienced ORACLE DBA and Datawarehouse architect:

Choosing the architecture, installations and migrations, ensuring the high availability and tuning of ORACLE Databases.
SQL, PL/SQL, RMAN, OEM, TOAD, IGNITE, DB OPTIMIZER, DOUBLE-TAKE, STANDBY…

Defining the business needs with user, extracting transforming and loading the datas in a DatawareHouse. Creating and maintainging models and reports.
IBM COGNOS DATA MANAGER, FRAMEWORK MANAGER, TRANSFORMER, QUERY, ANALYSIS and REPORT Studio.