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
- 8551 Views
- ComNet, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / the_xxx
You can use the below macro (#prompt("dataitem")#)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What is a Folder?
How do we drill through from a powerplay cube to reportnet?\
What is called Cognos powerplay?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
What are query items?
How to test a cube?
What is meant by grouped star schema
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.
what is the difference between enterprise data warehouse and data warehouse
How to crate cubes in transformer ?
Teradata 
