Interested to Buy Any Domain ? << Click Here >> for more details...
What is an open session command in cognos connection?what
is it meant for?
- 1 Answers
- 13732 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What do you understand by the term 'aggregate advisor?'
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Can you define metrics designer?
How Metrics Studio is better than Report Studio?
1. Explain your project.
What is the difference between Open Connection command ang Open Session Command?
What are all the types of gateway used in Cognos?
What is the difference between regular dimension and derminant?
tell me two or three issues from client side and how to solve those issues?
How do you improve the performance of the Cognos Analytics report
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What are various types of gateways in cognos?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
