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.

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?

7 Answers  

---

What is stitched Query?

5 Answers  

---

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

---

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

0 Answers   Wipro,

---

I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

0 Answers  

---

Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me

3 Answers  

---

what is the automation tool used for data warehouse testing???

3 Answers   Covansys, IBM, Wipro,

---

What is Bitmap Index?

0 Answers  

---

Wht is difference between content store and content manager?

2 Answers   Satyam, Tech Mahindra,

---

What are all types of prompt?

1 Answers  

---

What is difference between drill through and drill down?

3 Answers  

---

How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.

1 Answers  

---