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

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  

---

what is mean by complex starschema ,star schemagrouping?

0 Answers  

---

1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  

---

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

0 Answers  

---

What are all the components of Report Studio?

0 Answers  

---

What is content store?

1 Answers   HCL,

---

How the Bursting happens in same report and how to Print the bursting Report?

0 Answers   IBM,

---

What is the difference between macro & Parameter

1 Answers   IBM,

---

what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,

---

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

---

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?

3 Answers   ComNet,

---

hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance

26 Answers   IBM,

---