What is the difference between macros and prompt?
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 2 Yes | 4 No |
what is the difference between aggregation and roll up aggregation?
How to pass parameter value into html design page?
How is possible this scenario using in type-in prompt.?
how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please
What is snapshot ?
What is meant by junk dimension?
Explain informatica architecture?
What are various types of gateways in cognos?
15. If I select the current month and year how can we display previous 11 months data?
what is render variable
5 Answers Accenture, Cap Gemini, Systime, TCS,
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 ?
What is a Datastore in Cognos?