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....

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1699


what are slowly changing dimensions? Why we are used scd?

620


What is catalog and types of catalogs in cagonos and which is better?

521


Write various indexes used in cognos?

560


Can you define dimension?

641






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.

1728


Give the advantages of cognos?

584


tell me two or three issues from client side and how to solve those issues?

1705


Can you explain a cognos controller?

605


What is a Framework manager?

565


how u will determine the performence tune will occur either in report or system

1690


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1553


What is Additive function?

1561


What are the message flows?

561


hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

1783