Answer / harisudhakar velagacherla

Value Prompt Limitation:
If you do prompting for a range of values(specified range)
using IN_RANGE operator,under FROM and TO tabs a range of
available values will be displayed.In that you need to
select the values.Incase if the available values are in a
range of decimals ,it is difficult to select .
EX:0-5000$(values to be prompted).You can not enter this
specified range.under FROM tab, you need to search for 0&
value and under TO tab ,you need to select 5000& from the
available values.Values displayed under FROM ,TO tab will
be in random.imagine if the values are in decimals
(ex:5000.009) ,then Is it easy to select the value
(5000.009)under TO tab ,if the values displayed in random?

To overcome this...we need to go for Text PROMPT for
prompting Specified range.what ever range you specified ,it
willbe get prompted.
when you need to cascade,use either value or select&search
Prompt.


Select & search Prompt:


when you need prompt the values that contains or starts
with specific characters then,enter them under SELECT tab
and then click SEARCH tab.Then maching values will be
displayed in search box.select the values and click right
arrow to move this values to diplay box and click finish
(click next if another prompt presents).
in short it is used to display one 0r multiselect values
(=,IN operators).IN_Range operator cannot be available.

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 Answers  

---

How to hide/unhide the prompts which are not used by unauthorized users?

3 Answers  

---

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

---

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

---

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  

---

What are Governer Settings?

2 Answers  

---

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  

---

give me scenario on cascading prompts&master-detail relation

4 Answers   IBM,

---

What's use of a Master Detail report in Cognos? I mean what's the advantage? Please Explain.

2 Answers   DELL,

---

2.How do you drill through report from Report Studio to Analysis studio?

3 Answers   IBM,

---

I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

0 Answers   Infosys,

---

What are shortcuts? Where it can be used? What are the advantages?

0 Answers  

---