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 / rizwan
hi buddy use ?promptname? in sql
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How can we create a dynamic column name in cognos?
Define query studio?
-----------------What is Direct and Conventional loading?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what are the special features in cognos reportnet?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What are the message flows?
How create measures and dimensions?
What is metric store database?
Can you define cognos decision stream?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
Explain what is the main advantage of impromptu over cognos reportnet?
Can you define report item?
What is the model filter?
How is cognos model organization works?