Answer / chandrasekar. p

After creating boolean variable we will assign variable 'Yes' as 'True' and 'No' as 'False' from using block/style variable in cognos report studio.

Answer / suman palisetty

write a case statement

case when [data item] ='Yes'
then 'True'
else 'False'
end

Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?

7 Answers   Blue Cross Blue Shield Association, TCS,

---

How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.

3 Answers   Kudos India,

---

In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

Can you define set to be cardinality?

0 Answers  

---

i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,

---

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

0 Answers  

---

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  

---

-------------How to create a PortalTab?

1 Answers   Cap Gemini,

---

if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,

---

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,

---

How will u execute a stored procedute from a reportstudio

2 Answers   Cap Gemini,

---