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 |
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
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?
What you mean by drill across?
Where do you edit cognos sql in report studio?
what is reprompt?
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
Can you define a query subject?
what is loop in frameworkmanager ?
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
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
What is the enterprise class platform architecture of cognos 8?
what is an sid (surrogate key)?