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?
Answer Posted / mac
Suppose u have a prompt which has country code, u can use
that parameter in ur sqls to filter particular contry's
details.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How Metrics Studio is better than Report Studio?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Can you define slice?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What do you mean by drill through report?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is the information present in the cognos configuration file?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
WHAT ARE THE DISTNICT VARIABLES?
Can you define bitmap index?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How to create model and how to test model?
Can you define materialized view?
Name the types of report?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?