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 |
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
write a query to display the third record from the employee table?
--------------How to do Report Testing in Reports?
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
what is a Galaxy Schema?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
Explain the Difference Between Bursting and Scheduling?
What is meant by Tabular SQL in Cognos Report net
Hi, How the relations will be exists in DMR models if u have any idea please explain me
what is view? types of views?
if a page have 3different layouts(list,crosstab,chart)can you show the 3 leyouts in 3 different formates (pdf,excel,csv)?
What is the difference between drill through, drill across?