What is an open session command in cognos connection?what
is it meant for?
Answer / subhash
open session command is used to connect to the database to
the language defined. if i want to connect to the oracle
database with the language French then i will use the open
session command like this
<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = FRENCH
</sql>
</sqlCommand>
</commands>
</commandBlock>
again if i want to reset my connection to the english
language then i have to use close connection command.
<commandBlock>
<commands>
<sqlCommand>
<sql>ALTER SESSION SET NLS_LANGUAGE = ENGLISH
</sql>
</sqlCommand>
</commands>
</commandBlock>
| Is This Answer Correct ? | 0 Yes | 1 No |
how to improve the report performance?
is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)
we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
9. What was the most complex type of report you dealt with?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
Whrer u can save the Report net documentation in our local system?
Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?