adspace
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
Answer Posted / Navram Singh
In Cognos, you can create prompts for your queries. Here's an example of how you might set up the prompts for your requirements:
1. First Query (Show all values): You can simply create a query without any prompts if you want to show all values. The prompt will not be needed in this case because all data is being displayed.
2. Second Query (Show 3 values and hide 3 values): You can use the Prompt Builder to create a prompt for your users to input the specific records they want to view, while hiding others. Here's an example:
- Create a new prompt with appropriate properties such as name, type, etc.
- In the prompt settings, select the necessary fields you want the user to input. For example, select the first 3 and last 3 fields.
- Configure the prompt to hide the remaining values in your query by using the `case` statement:
```sql
CASE
WHEN <selected field> = <user's input> THEN <visible field>
ELSE NULL
END AS <alias name>
```
- Repeat this process for all fields you want to hide or show based on user input.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
faq's on cognos
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
what are the dimensions that you have in your current project?list them?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
what are the names of the reports that you prepared?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What r the names of the reports that you prepared?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com