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
what is power prompt in cognos ep7series?what is the use of this?
Define query items?
What is the difference between ‘macro’ and ‘prompt?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What is cognos reporting tool?
Can you define a catalog and types of catalogs in cognos?
What is difference between informatica power mart and power center?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
How to deploy from one server to another server?
Can you explain model durability?
how you provide security to reports? How you provide security to packages ?
Define cognos report net?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
Can you define a datastore in cognos?