suppose a value prompt contains 100 values and i want to
select all values in that prompt....i want ALL option in
the value prompt? how can u keep this option in value
prompt?
Answer Posted / thanjairajan@gmail.com
Hi Everybody, This is very simple.don't have any calculation to solve this question.
1.Drag any one of the data container to the work area.
2.Adding data item to the container
3.Create prompt page
4.When we Add value prompt to the prompt page. we create parameter then select package item, and then when we select operator we will see more operator like =,<,>,<=,>=,in,not in, in_range. in that operator we should select in_range operator.
5.After that we do normal procedure .
6.when we run the report, If the value prompt contain 100 numerical values, we should select 1 in From drop down box and select 100 in To drop down box. If the value prompt contain char type .that is it may contain product name,select first product name in From drop down box then select last product name in To drop down box.
7.Finally in report output we will see all values in value value prompt instead of particular value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is model and say about process how to create model and how to test model?
How to generate cubes in cognos?
What are the components of report net?
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..
----------------Diff b/w Dimensional modeling and Relational modeling?
How do you call a store procedure within a transformation?
Can you explain model durability?
what is power prompt in cognos ep7series?what is the use of this?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
how to perform single sign in cognos by using url?
What are the different uses of a repository manager?
What is a Cube?