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
- 8534 Views
- ComNet, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
how can you get the errors in job? when loops are araised we get error?
What is the complex report you faced in real time?
What is set to be cardinality?
----------------Describe DWH Architecture?
What is the difference between group and associare?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What is zero-foot print?
New coloums are added in database, then how you know in report level
How to deploy from one server to another server?
What is the difference between Open Connection command ang Open Session Command?
Can you explain model durability?
what is degenerate key in oracle ?whare do we use it?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
--------------Explain Table of contents?
