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 / the_xxx
You can use the below macro (#prompt("dataitem")#)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is meant by junk dimension?
Is it possible to join multiple Databases in a Catalog?
What is a Pivot?
Can you define a datastore in cognos?
Explain what is the difference between native sql and cognos sql?
Write types of folders present in cognos?
faq's on cognos
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
how u will design the report if the objects are available
How can you link a query to a data container manually in Report Studio?
What are the components used in web tier?
-------------What is Coditional Prompting?
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...
Can you define cognos impromptu?