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 |
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
what is model and how to create model and how to test model?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
What actually a project contains?
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?
how to perform single sign in cognos by using url?
in u r data u having duplicates how to fetch the latest data in our report?
What are links & Segments in Cognos Framework Manager?
How do you Parametermap variables in Quiries?
what is the role of cognos comsultant?what actually it means?pls reply
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer