Answer / 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.

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 Answers  

---

plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

1 Answers  

---

What is Performance Tunning Test?

2 Answers   IBM,

---

Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....

3 Answers   Deloitte,

---

What is Parametermap?

2 Answers  

---

When we save a report in report studio with what extn it save?

1 Answers  

---

Can you define query studio?

1 Answers  

---

Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  

---

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1 Answers  

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

1 Answers   Satyam,

---

How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,

---

What is meant by drill down?

1 Answers  

---