how can you restrict the number of values available for a
prompt?
i tried this by using static choices property, but i dint
get result... so pls explain in detail steps....
- 3 Answers
- 7640 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandra
when you create prompt report studio create a separate query
for that prompt. in this query write the filter condition.
It will filter the prompt values in prompt.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vij
hi
Click that particular prompt and go to the Properties
pane , in that select the property Rows Per Page and set
the value that u want e.g. 5000,100000 etc.
Hope it will help u
Thanks,
vij
:)
| Is This Answer Correct ? | 4 Yes | 10 No |
16. How can we create top 10 and bottom 10 records in the same list?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is the difference between macro & Parameter
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
If there are two values at value prompt level and when selecting first value it have to go to date prompt and when selecting second value we have to get output without any prompting. How to solve this issue. if any plz mail me on this vasuattada@yahoo.co.in
when can i use the STAR Schema and SNOWFLAKE Scgena
What is namespace and what it holds?
What do you mean by drill through report?
we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
Teradata 
