Answer / amar

Database functions nothing but Sql functions

Report functions nothing but Cognos functions.

While creating reports, Instead of cognos functions use sql
functions at Maximum. Because performance..

What is Fullouterjoin?

0 Answers  

---

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

4 Answers   IBM,

---

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,

---

what is meaning by Master detailed relationship ? please explain one example

4 Answers  

---

A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt

1 Answers  

---

---

advantages of detailed filter??? and summarized filter???

4 Answers   iFlex,

---

what is field set? what is the query calculation and layout calculation?

2 Answers   Syntel,

---

Explain the difference between powerplay transformer and power play reports?

0 Answers  

---

how u create security to reports ????

10 Answers   iFlex, iGate,

---

what is the difference between enterprise data warehouse and data warehouse

4 Answers  

---

How to upgrade drivers in Cognos 8?

1 Answers  

---

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers  

---