Answer / uzval_vee

Macro is set of insructions to run report.

Prompt is just like a dialog box which will ask user to
select/enter the information what he needs.

postthe new answer if it wrong

Answer / s.srinivas

A MACRO IS RUN TIME PARAMETER WHICH CAN BEPLACED IN ANY
PART OF SQL SELECT STATEMENT,WHERE AS PROMPT IS USED TO
GIVE CONDITIONS

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab to List? 2.How do you approach and who tells you what exactly the way report has to be developed so that i meets the client requirements? 3.Can we link the List and Chart thats created in the same report? 4.Where do you edit sql in cognos8 ? 5.What is the difference between native sql and oracle sql? 6.What is the difference between MOLAP and ROLAP? 7.What is the use of BI in datwarehousing? 8.What are set functions? 9.How do you test a report? 10.What are the variables you find in toolbox? 11.How many types of filters are there in cognos8? All the answers r welcomed .U can reach me at vinod.davala@gmail.com

4 Answers   IBM,

---

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

7 Answers   Cognizant, Cognos,

---

What you mean by drill across?

0 Answers  

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---

what is reprompt?

3 Answers   TCS,

---

Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!

2 Answers  

---

Can you define a query subject?

0 Answers  

---

what is loop in frameworkmanager ?

4 Answers   Texas,

---

I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?

4 Answers   IBM, TCS,

---

What is the enterprise class platform architecture of cognos 8?

0 Answers  

---

what is an sid (surrogate key)?

2 Answers   IBM, Oracle,

---