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 are initial page components of Cognos connection?
What is a Transformer?
What is a Cube?
whats the difference between previous version of cognos and cognos 8 BI?
what is the difference between filter and condition?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is main advantage datawarehousing over oracle?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Define the slice and dice?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What are the themes in a data warehouse?
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
Can you explain dynamic query mode?