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?
- 3 Answers
- 8573 Views
- ComNet, I also Faced
- E-Mail Answers
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
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
How to publish a package by running Java Script?
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?
What is a Folder?
What is a Transformer?
what is online view?
Explain the difference between native sql and cognos sql?
what are the dimensions that you have in your current project?list them?
How to test a cube?
what is model and say about process how to create model and how to test model?
Explain what is the difference between microstrategy and cognos reporting tool?
What is the importance of having monitor service in cognos?
How to create a cube in Transformer? What is the process? Please mention process thank u
Can you define confirmed dimension?
